MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Newbie Trying to Expedite Query
Posted by: Mike Lischke
Date: June 07, 2013 01:30AM

Well, yes, if you don't need any other part indexed and it fits otherwise then why not combining the auto inc field with the other two into a comming PK index? Since an index is ordered (you can even specify ascending or descending direction) you won't need an order by clause anymore.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

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


Subject
Views
Written By
Posted
Newbie Trying to Expedite Query
1320
Ron Mittelman
May 30, 2013 05:11PM
Re: Newbie Trying to Expedite Query
765
Mike Lischke
June 03, 2013 01:24AM
Re: Newbie Trying to Expedite Query
687
Ron Mittelman
June 03, 2013 10:54AM
Re: Newbie Trying to Expedite Query
700
Mike Lischke
June 04, 2013 02:09AM
Re: Newbie Trying to Expedite Query
610
Ron Mittelman
June 04, 2013 09:25AM
Re: Newbie Trying to Expedite Query
624
Mike Lischke
June 07, 2013 01:30AM


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.