############################################################## ## plan with out hint ################################################################################# select * from table(dbms_xplan.display('PLAN_TABLE','plan1','ALL')); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------- Plan hash value: 3734959255 -------------------------------------------------------------------------------------------------------------------------------------------- - | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | -------------------------------------------------------------------------------------------------------------------------------------------- - | 0 | SELECT STATEMENT | | 728K| 374M| 450K (1)| 01:30:02 | | | | | | | 1 | SEQUENCE | DEVX_EVENT_SEQ | | | | | | | | | | | 2 | PX COORDINATOR | | | | | | | | | | | | 3 | PX SEND QC (RANDOM) | :TQ10001 | 728K| 374M| 450K (1)| 01:30:02 | | | Q1,01 | P->S | QC (RAND) | |* 4 | FILTER | | | | | | | | Q1,01 | PCWC | | | 5 | NESTED LOOPS OUTER | | 728K| 374M| 450K (1)| 01:30:02 | | | Q1,01 | PCWP | | |* 6 | HASH JOIN | | 583K| 288M| 206K (2)| 00:41:23 | | | Q1,01 | PCWP | | | 7 | BUFFER SORT | | | | | | | | Q1,01 | PCWC | | | 8 | PX RECEIVE | | 4197 | 41970 | 14 (0)| 00:00:01 | | | Q1,01 | PCWP | | | 9 | PX SEND BROADCAST| :TQ10000 | 4197 | 41970 | 14 (0)| 00:00:01 | | | | S->P | BROADCAST | | 10 | INDEX FULL SCAN | MANUFACTURER_BB_PK | 4197 | 41970 | 14 (0)| 00:00:01 | | | | | | | 11 | PX BLOCK ITERATOR | | 624K| 302M| 206K (2)| 00:41:23 | 23 | 23 | Q1,01 | PCWC | | |* 12 | TABLE ACCESS FULL | TXN_BB | 624K| 302M| 206K (2)| 00:41:23 | 23 | 23 | Q1,01 | PCWP | | |* 13 | INDEX RANGE SCAN | DEVX_EVENT_F1 | 1 | 20 | 3 (0)| 00:00:01 | | | Q1,01 | PCWP | | -------------------------------------------------------------------------------------------------------------------------------------------- - Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SEL$1 10 - SEL$1 / D@SEL$1 12 - SEL$1 / A@SEL$1 13 - SEL$1 / B@SEL$1 Predicate Information (identified by operation id): --------------------------------------------------- 4 - filter("B"."EVENT_ID" IS NULL) 6 - access("A"."MANUFACTURER"="D"."MFR_NAME") 12 - filter("A"."BDS_DATE_CREATED"'DL' OR "A"."METHOD"<>'3') AND "A"."BDS_DATE_CREATED">=TO_DATE('2008-04- 05 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND ("A"."RESTRICT_FLAG"<>'Y' OR NVL("A"."EXT_COUNT",0)<>0) AND "A"."TYPE"<>'DA' AND "A"."TYPE"<>'TR' AND "A"."TYPE"<>'ER' AND "A"."TYPE"<>'CA') 13 - access("B"."PC_NAME"(+)='Verizon' AND "B"."EVENT_ID"(+)=TO_CHAR("A"."EVENTID")) Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - "D"."MFR_NAME"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "D".ROWID[ROWID,10], "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "B".ROWID[ROWID,10], "B"."PC_NAME"[VARCHAR2,720], "B"."EVENT_ID"[VARCHAR2,150] 2 - "D"."MFR_NAME"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "D".ROWID[ROWID,10], "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "B".ROWID[ROWID,10], "B"."PC_NAME"[VARCHAR2,720], "B"."EVENT_ID"[VARCHAR2,150] 3 - (#keys=0) "D"."MFR_NAME"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "D".ROWID[ROWID,10], "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "B".ROWID[ROWID,10], "B"."PC_NAME"[VARCHAR2,720], "B"."EVENT_ID"[VARCHAR2,150] 4 - "D"."MFR_NAME"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "D".ROWID[ROWID,10], "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "B".ROWID[ROWID,10], "B"."PC_NAME"[VARCHAR2,720], "B"."EVENT_ID"[VARCHAR2,150] 5 - (#keys=0) "D"."MFR_NAME"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "D".ROWID[ROWID,10], "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------- "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "B".ROWID[ROWID,10], "B"."PC_NAME"[VARCHAR2,720], "B"."EVENT_ID"[VARCHAR2,150] 6 - (#keys=1) "D"."MFR_NAME"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "D".ROWID[ROWID,10], "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720] 7 - (#keys=0) "D"."MFR_NAME"[VARCHAR2,720], "D".ROWID[ROWID,10] 8 - "D"."MFR_NAME"[VARCHAR2,720], "D".ROWID[ROWID,10] 9 - (#keys=0) "D"."MFR_NAME"[VARCHAR2,720], "D".ROWID[ROWID,10] 10 - "D".ROWID[ROWID,10], "D"."MFR_NAME"[VARCHAR2,720] 11 - "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7] 12 - "A"."EVENTID"[NUMBER,22], "A"."PRIMARY_CARRIER_NAME"[VARCHAR2,720], "A"."SID"[VARCHAR2,720], "A"."MANUFACTURER"[VARCHAR2,720], "A"."MFG_PARTNO"[VARCHAR2,90], "A"."MFG_PARTNAME"[VARCHAR2,720], "A"."ITEM_NAME"[VARCHAR2,720], "A"."GMT"[DATE,7], "A"."TYPE"[VARCHAR2,720], "A"."METHOD"[VARCHAR2,30], "A"."BASIS"[VARCHAR2,3], "A"."VALUE"[VARCHAR2,720], "A"."LANGUAGE"[VARCHAR2,12], "A"."API"[VARCHAR2,60], "A"."DAP"[NUMBER,22], "A"."ADJUSTMENT_REASON"[VARCHAR2,720], "A"."ADJUSTMENT_DAP"[NUMBER,22], "A"."ADJUSTMENT_EVENTID"[NUMBER,22], "A"."RESTRICT_FLAG"[VARCHAR2,3], "A"."NETWORK_FLAG"[VARCHAR2,3], "A"."EXT_COUNT"[NUMBER,22], "A"."DAP_CURRENCY"[VARCHAR2,9], "A"."ITEMID"[VARCHAR2,720], "A"."PLATFORMID"[NUMBER,22], "A"."BILLING_LEVEL"[NUMBER,22], "A"."ITEM_LIST_NAME"[NVARCHAR2,4000], "A"."BILL_FLAG"[VARCHAR2,3], "A"."PRICE_TYPE"[NUMBER,22], "A"."PRICE_TYPE_NAME"[NVARCHAR2,4000], "A"."GPS_FLAG"[VARCHAR2,3], "A"."SUBSTART_BILLDATE"[DATE,7], "A"."SUBEND_BILLDATE"[DATE,7], "A"."SOURCE_TYPE"[VARCHAR2,60], "A"."APPTYPE"[VARCHAR2,45], "A"."SUBTYPE"[VARCHAR2,720], "A"."VENDORDATA"[VARCHAR2,4000], "A"."MIME_TYPE"[VARCHAR2,720], "A"."BDS_DATE_CREATED"[DATE,7] 13 - "B".ROWID[ROWID,10], "B"."PC_NAME"[VARCHAR2,720], "B"."EVENT_ID"[VARCHAR2,150] ##################################################################################################################################################################### ##################################################################################################################################################################### plan with index hint select * from table(dbms_xplan.display('PLAN_TABLE','plan2','ALL')); ##################################################################################################################################################################### Wed Oct 15 page 1 Index Column Definitions PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------- Plan hash value: 2839423163 -------------------------------------------------------------------------------------------------------------------------------------------- ----------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN- OUT| PQ Distrib | -------------------------------------------------------------------------------------------------------------------------------------------- ----------------- | 0 | SELECT STATEMENT | | 728K| 374M| 922K (1)| 03:04:26 | | | | | | | 1 | SEQUENCE | DEVX_EVENT_SEQ | | | | | | | | | | |* 2 | PX COORDINATOR | | | | | | | | | | | | 3 | PX SEND QC (RANDOM) | :TQ10001 | 728K| 374M| 922K (1)| 03:04:26 | | | Q1,01 | P- >S | QC (RAND) | |* 4 | FILTER | | | | | | | | Q1,01 | PC WC | | |* 5 | FILTER | | | | | | | | Q1,01 | PC WC | | | 6 | NESTED LOOPS OUTER | | 728K| 374M| 922K (1)| 03:04:26 | | | Q1,01 | PC WP | | |* 7 | HASH JOIN | | 583K| 288M| 435K (1)| 01:27:09 | | | Q1,01 | PC WP | | | 8 | BUFFER SORT | | | | | | | | Q1,01 | PC WC | | | 9 | PX RECEIVE | | 4197 | 41970 | 14 (0)| 00:00:01 | | | Q1,01 | PC WP | | | 10 | PX SEND BROADCAST | :TQ10000 | 4197 | 41970 | 14 (0)| 00:00:01 | | | | S- >P | BROADCAST | | 11 | INDEX FULL SCAN | MANUFACTURER_BB_PK | 4197 | 41970 | 14 (0)| 00:00:01 | | | | | | | 12 | PX PARTITION RANGE ITERATOR | | 624K| 302M| 435K (1)| 01:27:09 | KEY | KEY | Q1,01 | PC WC | | |* 13 | TABLE ACCESS BY LOCAL INDEX ROWID| TXN_BB | 624K| 302M| 435K (1)| 01:27:09 | KEY | KEY | Q1,01 | PC WP | | |* 14 | INDEX RANGE SCAN | TXN_BB1_N3 | 265K| | 9344 (1)| 00:01:53 | KEY | KEY | Q1,01 | PC WP | | |* 15 | INDEX RANGE SCAN | DEVX_EVENT_F1 | 1 | 20 | 3 (0)| 00:00:01 | | | Q1,01 | PC WP | | -------------------------------------------------------------------------------------------------------------------------------------------- ----------------- Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- Wed Oct 15 page 2 Index Column Definitions PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------- 1 - SEL$1 11 - SEL$1 / D@SEL$1 13 - SEL$1 / A@SEL$1 14 - SEL$1 / A@SEL$1 15 - SEL$1 / B@SEL$1 Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter(TO_DATE('05-Apr-2008')'DL' OR "A"."METHOD"<>'3') AND ("A"."RESTRICT_FLAG"<>'Y' OR NVL("A"."EXT_COUNT",0)<>0) AND "A"."TYPE"<>'DA' AND "A"."TYPE"<>'TR' AND "A"."TYPE"<>'ER' AND "A"."TYPE"<>'CA') 14 - access("A"."BDS_DATE_CREATED">=TO_DATE('05-Apr-2008') AND "A"."PRIMARY_CARRIER_NAME"='Verizon' AND "A"."BDS_DATE_CREATED"