Re: Query sorting without Order by

> Yes, but when a comment is in the right place with the right format,
> They are optimizer hints. They tell Oracle how to execute the
> query (rather than decide for itself). The hint below tells oracle to
> use the index MY_TABLE_X. When oracle uses the index, the rows will
> come back in the order of the index. That's how we can sort the rows
> without a sort!
>

I tried that, but it does not work.

Regards
Nicolas Received on Wed Feb 07 2001 - 02:34:25 CST