MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: simple SELECT index problem
Posted by: KimSeong Loh
Date: March 29, 2006 06:42PM

Maybe you can create a composite index (cfuFolderIDx,cfuUserIDx)
and chage your ORDER BY clsIDx to ORDER BY cfuUserIDx

This should be able to remove the filesort and maybe temporary

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
simple SELECT index problem
1597
K Mertens
March 29, 2006 01:15PM
Re: simple SELECT index problem
984
KimSeong Loh
March 29, 2006 06:42PM
Re: simple SELECT index problem
1033
K. Mertens
March 30, 2006 02:49AM


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.