sorting takes more time
My table contains more than 3 lakhs records.when I am sorting them it is taking more than 50 sec for sorting.Primary key of my table is a blob.For temporarily reducing the sorting time I set "max_sort_length" = 50. Can any body give me a permanent solution without reducing the max_sort_length. I want to reduce the sorting time to be less than 10sec.
Any information related to this will help me a lot.
Thanks & Regards,
B.T.S.murthy.
<bmurthy@cordys.com>
Subject
Views
Written By
Posted
sorting takes more time
2861
March 14, 2005 12:44AM
1463
March 14, 2005 02:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.