Re: NULLS FIRST option in CREATE INDEX?

Tanel Poder wrote:

> 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.
>
> <snipped>

To which it should be added that Oracle doesn't index NULLs.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)