Re: SUBQUERY PROBLEM - Optimizer Team
Index distinct
PRIMARY KEY idnm1_customer_exempt = 27010 rows
INDEX KEY IDX_FromDate (FromDate) = 2 rows
KEY `IDX_ToDate` (`ToDate`),
KEY `IDX_FromDateToDate` (`FromDate`,`ToDate`) = 2 rows
KEY `IDX_SubmarketCode` (`Submarket`) = 19 rows
KEY `IDX_ALL` (`Market`,`Entity`,`Submarket`,`CurrencyCode`,`Customer`) = 15367 rows
Thanks!
Odimar
Subject
Views
Written By
Posted
3924
February 07, 2006 04:21PM
2484
February 07, 2006 04:45PM
2432
February 07, 2006 04:52PM
2518
February 08, 2006 04:57AM
2392
February 08, 2006 03:59PM
2449
February 08, 2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team
2437
February 08, 2006 10:26AM
2605
February 13, 2006 11:06AM
2521
February 13, 2006 11:17AM
2439
February 13, 2006 11:22AM
2354
February 13, 2006 12:16PM
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.