Re: How to optimize a derived table required for re-ordering.
Posted by:
Toa Sty
Date: January 15, 2007 08:41AM
Could be that your inner query is returning a col type that can't go in an in-memory table. In memory temp tables can only be used if all the cols are supported by the MEMORY/HEAP table type, otherwise MySQL puts the temp table on disk. (MyISAM format)
BTW - I'm probably missing something, but why don't you just order by final_sort_order or (final_sort_order,sort_field) to begin with?
Toasty
-----------------------------------------
email: 'toasty'*3 at gmail
Subject
Views
Written By
Posted
4061
November 25, 2006 05:58AM
Re: How to optimize a derived table required for re-ordering.
3086
January 15, 2007 08:41AM
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.