Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NULLS FIRST option in CREATE INDEX?

Re: NULLS FIRST option in CREATE INDEX?

From: Alanoly J. Andrews <alanolya_at_invera.com>
Date: 20 Jun 2003 06:56:30 -0700
Message-ID: <e76061b9.0306200556.4e415d4@posting.google.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US