Re: Query sorting without Order by

On Wed, 7 Feb 2001 09:34:25 +0100, "Nicolas Bronke" <newsgroup_at_trinity.de> wrote:

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

I think that hint's require that the optimiser is set to COST or CHOOSE. Perhaps you're using RULE based?

-- 
Suck The Goat