Re: how to optimise query for 10+ millions records
Posted by:
Rick James
Date: February 18, 2012 07:18AM
Using indexed fields inside function calls (such as IF()) makes it so the indexes cannot be used. Reforumate thus:
JOIN IN_ROUTE on p_CarrierType = 0 AND axecdr.IN_Route = IN_ROUTE.VALUE
JOIN OUT_ROUTE ON p_CarrierType = 1 AND axecdr.OUT_Route = OUT_ROUTE.VALUE
Subject
Views
Written By
Posted
3269
February 09, 2012 03:30AM
1839
February 09, 2012 05:31AM
1534
February 09, 2012 05:38AM
1421
February 09, 2012 05:58PM
1380
February 11, 2012 11:26PM
1650
February 12, 2012 10:12PM
1515
February 13, 2012 02:18PM
1716
February 14, 2012 02:33AM
1525
February 14, 2012 07:24AM
1536
February 15, 2012 07:30AM
1993
February 16, 2012 03:54AM
1415
February 17, 2012 01:20AM
1386
February 17, 2012 03:57PM
1656
February 17, 2012 05:12PM
Re: how to optimise query for 10+ millions records
1494
February 18, 2012 07:18AM
1510
February 21, 2012 03:25AM
1545
February 24, 2012 10:45AM
1466
February 20, 2012 02:21AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.