Re: Help with querying large table.
Can you try to do an Explain after removing the order by with the full index length.
And do a check, run your original select with order by
show status like 'sort_merge_passes';
select .....
show status like 'sort_merge_passes';
Does the value of sort_merge_passes increases? if it does, try to increase the sort_buffer_size to reduce the sorting using the disk.
Subject
Views
Written By
Posted
2245
October 04, 2005 10:04PM
1443
October 05, 2005 01:04AM
1654
October 05, 2005 06:41AM
Re: Help with querying large table.
1373
October 05, 2005 07:28PM
1439
October 10, 2005 12:07AM
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.