Quote Originally Posted by PAVB
I don't think so...




Your query hits a single table with no predicate, isn't that a book case study for Full Table Scan?

Do you have an index on APPNM column?
If yes... what happens if you take out the ORDER BY clause?
-----------

PAVB, You are mystery man

If order by is thrown away cost is 1/3 less.
I know that it is case study for FTS, so i don't know if it is possible to make that query to run faster.

Best Regards Arek Masny