Re: table index optimization
Hi Rick,
INDEX(primary_category, subsection_select, index_id) was chosen.
I also added another column to this index:
INDEX(primary_category, subsection_select, index_id, article_display_date)
Extra became: "Using where" and instead of scanning through 1k's of records it's 100's only now.
Thanks!
Matus
Subject
Views
Written By
Posted
2565
May 01, 2012 10:55AM
1250
May 02, 2012 07:08PM
1573
May 04, 2012 08:20AM
1444
May 05, 2012 09:07AM
Re: table index optimization
1295
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.