Re: table index optimization
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?
Subject
Views
Written By
Posted
2712
May 01, 2012 10:55AM
Re: table index optimization
1316
May 02, 2012 07:08PM
1661
May 04, 2012 08:20AM
1519
May 05, 2012 09:07AM
1404
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.