Could any one help me out on the following?
I have a query which returns about some 500K records and it is very slow if I put the 'ORDER BY' clause. It takes about 10 mins with sorting and only 9 seconds without the 'ORDER BY'. I have increased 'SORT_AREA_SIZE' but that didn't help me. Also I don't see much disk sorting. Disk sorting is less than 1%. I am on 8.1.7. What else I can do to take the query down to say less than minute? Thanks a lot.
Your help is greatly appreciated.