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
6294
June 01, 2009 03:07AM
3043
June 02, 2009 07:48PM
3125
June 03, 2009 12:58AM
2715
June 03, 2009 10:52PM
2746
June 04, 2009 01:07AM
3194
June 04, 2009 09:03AM
2734
June 04, 2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query
2738
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.