diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-04-25 13:03:37 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-04-25 13:03:37 +0000 |
| commit | 61cf53516eba02f8ae58da1acfa2db6bd129cab9 (patch) | |
| tree | f42bdd24b90afb8651b39d294e1c07c901d28b9b /src/backend/parser/parse_target.c | |
| parent | c5b08d3b7d95bc7e18ad4fa12254d1cf383b9a5a (diff) | |
| download | postgresql-61cf53516eba02f8ae58da1acfa2db6bd129cab9.tar.gz postgresql-61cf53516eba02f8ae58da1acfa2db6bd129cab9.zip | |
Re-add item with better description:
> * Allow ORDER BY ... LIMIT 1 to select high/low value without sort or
> index using a sequential scan for highest/lowest values
>
> Right now, if no index exists, ORDER BY ... LIMIT 1 requires we sort
> all values to return the high/low value. Instead The idea is to do a
> sequential scan to find the high/low value, thus avoiding the sort.
>
Diffstat (limited to 'src/backend/parser/parse_target.c')
0 files changed, 0 insertions, 0 deletions