MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Query that returns indexed fields involves FILESORT, why?
1945
March 01, 2010 08:28AM


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.