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
6335
June 01, 2009 03:07AM
3070
June 02, 2009 07:48PM
3149
June 03, 2009 12:58AM
2735
June 03, 2009 10:52PM
2763
June 04, 2009 01:07AM
3212
June 04, 2009 09:03AM
2749
June 04, 2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query
2755
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.