MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: performance issue on order by index
Posted by: Devart Team
Date: July 14, 2010 03:35AM

There is some information about LIMIT clause -
http://dev.mysql.com/doc/refman/5.1/en/limit-optimization.html

Try to get more information about query with EXPLAIN command -
http://dev.mysql.com/doc/refman/5.1/en/explain.html
http://dev.mysql.com/doc/refman/5.1/en/using-explain.html

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

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


Subject
Written By
Posted
performance issue on order by index
Ed Wong
July 14, 2010 02:44AM
Re: performance issue on order by index
Devart Team
July 14, 2010 03:35AM
Re: performance issue on order by index
Rick James
July 14, 2010 11:27PM
Re: performance issue on order by index
sandeepji ji
July 15, 2010 02:32AM


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.