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
2541
May 01, 2012 10:55AM
Re: table index optimization
1241
May 02, 2012 07:08PM
1566
May 04, 2012 08:20AM
1434
May 05, 2012 09:07AM
1281
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.