-
Hi ,
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.
Thanks again.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|