Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NULLS FIRST option in CREATE INDEX?
"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3eee2e49$1_1_at_news.estpak.ee>...
> Hi!
>
> You should never rely on ordering that comes from using an index. If the
> index is not used for some reason, or fast full scan is used, you will
> probably get completely different-ordered result. Order by is a must if you
> want order.
>
> Tanel.
Hi Tanel,
The Order by should of course be used to make sure that the output is in the order you want. And if you have created an index with the same ordering as in the order by, you can use the optimizer hint to force the use of the index and thus avoid a SORT of the retrieved rows.
Alanoly Andrews. Received on Fri Jun 20 2003 - 08:56:30 CDT