Re: Get rid of Temporary/filesort, rather simple query
That seems better -- the estimated effort:
Before: 31728 * 3
Now: 1452 * 1
So, it might be (but probably isn't) 70x faster?
Subject
Views
Written By
Posted
6334
June 01, 2009 03:07AM
3070
June 02, 2009 07:48PM
3149
June 03, 2009 12:58AM
2734
June 03, 2009 10:52PM
2761
June 04, 2009 01:07AM
3212
June 04, 2009 09:03AM
2748
June 04, 2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query
2754
June 04, 2009 07:39PM
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.