Re: how to optimise query for 10+ millions records
Posted by:
Rick James
Date: February 24, 2012 10:45AM
INDEX(START_DATE) is likely to be as good or better than the compound one you provided.
The IF() clauses are preventing use of the last two fields of your index.
PARTITIONing is unlikely to help. Please provide your suggested PARTITION definition for critique.
Subject
Views
Written By
Posted
3195
February 09, 2012 03:30AM
1804
February 09, 2012 05:31AM
1476
February 09, 2012 05:38AM
1385
February 09, 2012 05:58PM
1344
February 11, 2012 11:26PM
1607
February 12, 2012 10:12PM
1468
February 13, 2012 02:18PM
1677
February 14, 2012 02:33AM
1486
February 14, 2012 07:24AM
1490
February 15, 2012 07:30AM
1937
February 16, 2012 03:54AM
1376
February 17, 2012 01:20AM
1327
February 17, 2012 03:57PM
1623
February 17, 2012 05:12PM
1435
February 18, 2012 07:18AM
1469
February 21, 2012 03:25AM
Re: how to optimise query for 10+ millions records
1500
February 24, 2012 10:45AM
1423
February 20, 2012 02:21AM
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.