| Subject | Re: Ordering with nulls first and index usage |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2012-12-01T08:53:31Z |
01.12.2012 1:26, Leyne, Sean wrote:
stored at the end.
Dmitry
>Correct.
> In order for an index to be used for ORDER BY, the sort order much match
> exactly the storage order of the index.
> All indexes have NULLs stored at the end (ie. not first).ASC indices have NULLs stored in the beginning, DESC indices have NULLs
stored at the end.
Dmitry