Re: sort without order by

Will it run faster if we force the use of the index?

Greg Stark <greg-spare-1_at_mit.edu> wrote:

> Norris <jcheong_at_cooper.com.hk> writes:

>> What is the purpose of having "where x > -99999999999999"?

>> > tkyte_at_8.0> select x from t where x > -99999999999999 order by x;

> To force the use of the index I think. actually in this case without it Oracle
> would not be able to use the index at all because x could be NULL. If x were
> NOT NULL and the table is analyzed Oracle would probably but not necessarily
> use the index anyways.

> --
> greg
Received on Sun Nov 21 1999 - 03:52:13 CST