Re: sort without order by

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Sun, 21 Nov 1999 07:32:58 GMT
Message-ID: <874seg8flb.fsf@HSE-Montreal-ppp19485.qc.sympatico.ca>

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 - 01:32:58 CST