|
ECT STATEMENT REMOTE | | 2 | 232 | 325 (1)| 00:00:05 | | | |
| 1 | NESTED LOOPS OUTER | | 2 | 232 | 325 (1)| 00:00:05 | | | |
| 2 | NESTED LOOPS | | 2 | 128 | 322 (1)| 00:00:05 | | | |
| 3 | NESTED LOOPS | | 12 | 576 | 310 (1)| 00:00:05 | | | |
|* 4 | HASH JOIN | | 12 | 420 | 274 (1)| 00:00:04 | | | |
| 5 | PARTITION RANGE ALL | | 98 | 1470 | 185 (1)| 00:00:03 | 1 | 39 | |
| 6 | INLIST ITERATOR | | | | | | | | |
| 7 | TABLE ACCESS BY LOCAL INDEX ROWID| TB_BA_SERV_HIST | 98 | 1470 | 185 (1)| 00:00:03 | 1 | 39 | GZODSD |
|* 8 | INDEX RANGE SCAN | IX_BA_SERVSERVID_HIST | 98 | | 100 (1)| 00:00:02 | 1 | 39 | GZODSD |
| 9 | PARTITION RANGE ALL | | 12 | 240 | 88 (0)| 00:00:02 | 1 | 39 | |
| 10 | TABLE ACCESS BY LOCAL INDEX ROWID | ORDER_ITEM_HIST | 12 | 240 | 88 (0)| 00:00:02 | 1 | 39 | GZODSD |
|* 11 | INDEX RANGE SCAN | IXH_ORDERITEM_STATDATE | 12 | | 79 (0)| 00:00:02 | 1 | 39 | GZODSD |
| 12 | TABLE ACCESS BY INDEX ROWID | TB_BA_ACTION_HIST | 1 | 13 | 3 (0)| 00:00:01 | | | GZODSD |
|* 13 | INDEX RANGE SCAN | IX_BA_ACT_SUBSID_HIST | 1 | | 2 (0)| 00:00:01 | | | GZODSD |
|* 14 | TABLE ACCESS BY INDEX ROWID | TB_PM_ACTION | 1 | 16 | 1 (0)| 00:00:01 | | | GZODSD |
|* 15 | INDEX UNIQUE SCAN | PK_PM_ACTION | 1 | | 0 (0)| 00:00:01 | | | GZODSD |
|* 16 | TABLE ACCESS BY INDEX ROWID | TB_BA_CHANNELSTAFF | 1 | 52 | 2 (0)| 00:00:01 | | | GZODSD |
|* 17 | INDEX UNIQUE SCAN | PK_CHANNELSTAFF_SUBS_ID | 1 | | 1 (0)| 00:00:01 | | | GZODSD |
--------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1
7 - SEL$F5BB74E1 / A3@SEL$1
8 - SEL$F5BB74E1 / A3@SEL$1
10 - SEL$F5BB74E1 / ORDER_ITEM_HIST@SEL$2
11 - SEL$F5BB74E1 / ORDER_ITEM_HIST@SEL$2
12 - SEL$F5BB74E1 / A4@SEL$1
13 - SEL$F5BB74E1 / A4@SEL$1
14 - SEL$F5BB74E1 / A2@SEL$1
15 - SEL$F5BB74E1 / A2@SEL$1
16 - SEL$F5BB74E1 / A1@SEL$1
17 - SEL$F5BB74E1 / A1@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
USE_NL(@"SEL$F5BB74E1" "A1"@"SEL$1")
USE_NL(@"SEL$F5BB74E1" "A2"@"SEL$1")
USE_NL(@"SEL$F5BB74E1" "A4"@"SEL$1")
USE_HASH(@"SEL$F5BB74E1" "ORDER_ITEM_HIST"@"SEL$2")
LEADING(@"SEL$F5BB74E1" "A3"@"SEL$1" "ORDER_ITEM_HIST"@"SEL$2" "A4"@"SEL$1" "A2"@"SEL$1" "A1"@"SEL$1")
INDEX_RS_ASC(@"SEL$F5BB74E1" "A1"@"SEL$1" ("TB_BA_CHANNELSTAFF"."SUBS_ID"))
INDEX_RS_ASC(@"SEL$F5BB74E1" "A2"@"SEL$1" ("TB_PM_ACTION"."ACTION_ID" "TB_PM_ACTION"."CITY_ID"))
INDEX_RS_ASC(@"SEL$F5BB74E1" "A4"@"SEL$1" ("TB_BA_ACTION_HIST"."SUBS_ID"))
INDEX_RS_ASC(@"SEL$F5BB74E1" "ORDER_ITEM_HIST"@"SEL$2" ("ORDER_ITEM_HIST"."STAT" "ORDER_ITEM_HIST"."STATUS_DATE"))
INDEX_RS_ASC(@"SEL$F5BB74E1" "A3"@"SEL$1" ("TB_BA_SERV_HIST"."SERV_ID"))
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$1")
MERGE(@"SEL$2")
OUTLINE_LEAF(@"SEL$F5BB74E1")
ALL_ROWS
OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("ORDER_ITEM_ID"="A3"."SUBS_ID")
8 - access("A3"."SERV_ID"=3745498320 OR "A3"."SERV_ID"=3751978420 OR "A3"."SERV_ID"=3751978950 OR "A3"."SERV_ID"=3751990561 OR
"A3"."SERV_ID"=3751991941 OR "A3"."SERV_ID"=3751992281 OR "A3"."SERV_ID"=3751992431 OR "A3"."SERV_ID"=3751992831 OR
"A3"."SERV_ID"=3 |