Re: query order clause and indices

Sorry to confuse...
The query below with hint is as it is now in prd. I am removing the hint when taking out the order by and in fact the LIO's are slightly lower without the hint favoring FTS anyway...

Query without order by does not include hint, althouhg I did try hinting at the index on the column that was referenced in the order by and the LIO's are slightly higher.

I'm going to check out your idea of index and order by...

-- 
..
David



>

>

>

>

> Gut feel would say that even though it doesn't appear to use the index

> perhaps it actually is at execution time - there is no other way the

> presence of an index can change the result set.


--
http://www.freelists.org/webpage/oracle-l