|
查询块。
--原来的执行计划和outline信息：
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 931544562
--------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | Inst |
--------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT REMOTE | | 2 | 232 | 296 (0)| 00:00:05 | | | |
|* 1 | TABLE ACCESS BY LOCAL INDEX ROWID | TB_BA_SERV_HIST | 1 | 15 | 79 (0)| 00:00:02 | | | GZODSD |
| 2 | NESTED LOOPS | | 2 | 232 | 296 (0)| 00:00:05 | | | |
| 3 | NESTED LOOPS OUTER | | 2 | 202 | 139 (0)| 00:00:02 | | | |
| 4 | NESTED LOOPS | | 2 | 98 | 136 (0)| 00:00:02 | | | |
| 5 | NESTED LOOPS | | 12 | 396 | 124 (0)| 00:00:02 | | | |
| 6 | PARTITION RANGE ALL | | 12 | 240 | 88 (0)| 00:00:02 | 1 | 39 | |
| 7 | TABLE ACCESS BY LOCAL INDEX ROWID| ORDER_ITEM_HIST | 12 | 240 | 88 (0)| 00:00:02 | 1 | 39 | GZODSD |
|* 8 | INDEX RANGE SCAN | IXH_ORDERITEM_STATDATE | 12 | | 79 (0)| 00:00:02 | 1 | 39 | GZODSD |
| 9 | TABLE ACCESS BY INDEX ROWID | TB_BA_ACTION_HIST | 1 | 13 | 3 (0)| 00:00:01 | | | GZODSD |
|* 10 | INDEX RANGE SCAN | IX_BA_ACT_SUBSID_HIST | 1 | | 2 (0)| 00:00:01 | | | GZODSD |
|* 11 | TABLE ACCESS BY INDEX ROWID | TB_PM_ACTION | 1 | 16 | 1 (0)| 00:00:01 | | | GZODSD |
|* 12 | INDEX UNIQUE SCAN | PK_PM_ACTION | 1 | | 0 (0)| 00:00:01 | | | GZODSD |
|* 13 | TABLE ACCESS BY INDEX ROWID | TB_BA_CHANNELSTAFF | 1 | 52 | 2 (0)| 00:00:01 | | | GZODSD |
|* 14 | INDEX UNIQUE SCAN | PK_CHANNELSTAFF_SUBS_ID | 1 | | 1 (0)| 00:00:01 | | | GZODSD |
| 15 | PARTITION RANGE ALL | | 1 | | 78 (0)| 00:00:02 | 1 | 39 | |
|* 16 | INDEX RANGE SCAN | IX_BA_SERVSUBSID_HIST | 1 | | 78 (0)| 00:00:02 | 1 | 39 | GZODSD |
--------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F5BB74E1 / A3@SEL$1
7 - SEL$F5BB74E1 / ORDER_ITEM_HIST@SEL$2
8 - SEL$F5BB74E1 / ORDER_ITEM_HIST@SEL$2
9 - SEL$F5BB74E1 / A4@SEL$1
10 - SEL$F5BB74E1 / A4@SEL$1
11 - SEL$F5BB74E1 / A2@SEL$1
12 - SEL$F5BB74E1 / A2@SEL$1
13 - SEL$F5BB74E1 / A1@SEL$1
14 - SEL$F5BB74E1 / A1@SEL$1
16 - SEL$F5BB74E1 / A3@SEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
USE_NL(@"SEL$F5BB74E1" "A3"@"SEL$1")
USE_NL(@"SEL$F5BB74E1" "A1"@"SEL$1")
USE_NL(@"SEL$F5BB74E1" "A2"@"SEL$1")
USE_NL(@"SEL$F5BB74E1" "A4"@"SEL$1")
LEADING(@"SEL$F5BB74E1" "ORDER_ITEM_HIST"@"SEL$2" "A4"@"SEL$1" "A2"@"SEL$1" "A1"@"SEL$1" "A3"@"SEL$1")
INDEX(@"SEL$F5BB74E1" "A3"@"SEL$1" ("TB_BA_SERV_HIST"."SUBS_ID"))
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"))
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$1")
MERGE(@"SEL$2")
OUTLINE_LEAF(@"SEL$ |