MySQL Forums
Forum List  »  Optimizer & Parser

Re: table index optimization
Posted by: Rick James
Date: May 02, 2012 07:08PM

Please provide SHOW CREATE TABLE.

> ORDER BY articles.`index_id` ASC , articles.`article_display_date` ASC
Don't you want the date first, especially if index_id is unique?

Learn about "compound" indexes. Perhaps this one would be good:
INDEX(primary_category, subsection_select, index_id)

How big is the table?

Options: ReplyQuote


Subject
Views
Written By
Posted
2384
May 01, 2012 10:55AM
Re: table index optimization
1161
May 02, 2012 07:08PM
1484
May 04, 2012 08:20AM
1355
May 05, 2012 09:07AM
1187
May 17, 2012 09:25AM


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.