Re: Composite index - selecting components and order
I'm just finishing a restructure where i have a new table holding my GROUP BY structure, removing that from the equation most times.
I've also restructured so that the ORDER BY is also rarely used.
So I really need to concentrate on optimizing indicies for the SELECT and WHERE items. And yes, there are most usually a significant number of items in the IN clauses.
I'll look into the bulk of your suggestions tomorrow when I have a chance to really look at them.
Thanks for any input.
Subject
Views
Written By
Posted
2397
May 04, 2013 10:54AM
1065
May 06, 2013 10:47PM
1074
May 07, 2013 08:05PM
Re: Composite index - selecting components and order
938
May 07, 2013 08:40PM
1013
May 08, 2013 06:55AM
1001
May 08, 2013 09:54PM
1539
May 09, 2013 10:46PM
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.