Re: Get rid of Temporary/filesort, rather simple query
Posted by:
Reine n/a
Date: June 04, 2009 03:06PM
To begin with I like to thank you for helping me out.
I added a PRIMARY KEY to pm2user with conversation_uuid and user_id and ran your updated query.
Index_1 contains user_id & folder_id.
Here is the result.
id select_type table type key rows Extra
1 SIMPLE p2u ref Index_1 1452 Using where; Using temporary; Using filesort
1 SIMPLE pm ref uuid_datetime 1
Subject
Views
Written By
Posted
6157
June 01, 2009 03:07AM
2988
June 02, 2009 07:48PM
3072
June 03, 2009 12:58AM
2665
June 03, 2009 10:52PM
2694
June 04, 2009 01:07AM
3132
June 04, 2009 09:03AM
Re: Get rid of Temporary/filesort, rather simple query
2683
June 04, 2009 03:06PM
2688
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.