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
6279
June 01, 2009 03:07AM
3035
June 02, 2009 07:48PM
3115
June 03, 2009 12:58AM
2711
June 03, 2009 10:52PM
2739
June 04, 2009 01:07AM
3188
June 04, 2009 09:03AM
2726
June 04, 2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query
2730
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.