MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Query that returns indexed fields involves FILESORT, why?
Posted by: Yurij Zagrebnoy
Date: March 01, 2010 08:28AM

I wanted to understand how MySQL handles such queries. Thank you for the reply.

My actual queries use LIMIT and SQL_CALC_FOUND_ROWS to represent data by pages for the user and complicated WHERE conditions to do various operations on it.

I've found it not so easy to analyze how to improve such queries' performance with MySQL, need to learn better how it works.

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


Subject
Views
Written By
Posted
Query that returns indexed fields involves FILESORT, why?
4598
Yurij Zagrebnoy
February 26, 2010 12:36PM
Re: Query that returns indexed fields involves FILESORT, why?
2311
Rick James
February 28, 2010 01:36PM
Re: Query that returns indexed fields involves FILESORT, why?
2042
Yurij Zagrebnoy
March 01, 2010 08:28AM
Re: Query that returns indexed fields involves FILESORT, why?
2153
Rick James
March 01, 2010 01:16PM


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.