|
--------------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 1 | 352 | 16760 (2)| 00:03:55 |
| 1 | DELETE | TB_XX_XXXX_XXXX_XXX | | | | |
|* 2 | COUNT STOPKEY | | | | | |
|* 3 | TABLE ACCESS BY INDEX ROWID | TB_XX_XXXX_XXXX_XXX | 1 | 352 | 16760 (2)| 00:03:55 |
| 4 | BITMAP CONVERSION TO ROWIDS | | | | | |
| 5 | BITMAP AND | | | | | |
| 6 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 7 | INDEX RANGE SCAN | IX_AA_AAA_AAAAAAA | 1757K| | 14 (79)| 00:00:01 |
| 8 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 9 | INDEX RANGE SCAN | IX_AA_AAA_AAAAAAA_PLANID | 1757K| | 14 (79)| 00:00:01 |
| 10 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 11 | INDEX RANGE SCAN | IX_BB_BBB_BBBB_BBBBBB | 1757K| | 2787 (1)| 00:00:40 |
| 12 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 13 | INDEX RANGE SCAN | IX_CC_CCC_CCCC_CCCCCC | 1757K| | 13793 (1)| 00:03:14 |
---------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - DEL$1
3 - DEL$1 / TB_XX_XXXX_XXXX_XXX@DEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
BITMAP_TREE(@"DEL$1" "TB_XX_XXXX_XXXX_XXX"@"DEL$1" AND(("TB_XX_XXXX_XXXX_XXX"."LOG_ID")
("TB_XX_XXXX_XXXX_XXX"."PLAN_ID") ("TB_XX_XXXX_XXXX_XXX"."OP_DATE")
("TB_XX_XXXX_XXXX_XXX"."PLAN_RESULT")))
OUTLINE_LEAF(@"DEL$1")
ALL_ROWS
OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter(ROWNUM=1)
3 - filter("STAFF_CODE"=:B4 AND "WORK_STAFF"=:B5 AND "OP_TIME"=:B7 AND "LOG_NOTES"=:B8 AND
"LOG_NO"=TO_NUMBER(:B2) AND "UNIT_ID"=TO_NUMBER(:B9))
7 - access("LOG_ID"=TO_NUMBER(:B0))
9 - access("PLAN_ID"=TO_NUMBER(:B1))
11 - access("OP_DATE"=:B6)
13 - access("PLAN_RESULT"=TO_NUMBER(:B3))
Note
-----
- dynamic sampling used for this statement
--执行计划中一大堆的BITMAP关键字，很容易误以为这几个索引是bitmap索引，其实是普通索引来的。
--获取表和索引的相关信息
OWNER TABLE_NAME OBJECT_TYPE STA LAST_ANALYZED
-------------------- ------------------------------ ------------ --- -------------------
SPS_SZ TB_XX_XXXX_XXXX_XXX TABLE
--上表TB_XX_XXXX_XXXX_XXX统计信息过期
OWNER SEGMENT_NAME SEGMENT_TYPE Size(Mb)
-------------------- ------------------------------ -------------------- ----------
SPS_SZ IX_CC_CCC_CCCC_CCCCCC INDEX 8434.625
SPS_SZ IX_AA_AAA_AAAAAAA INDEX 11176.625
SPS_SZ IX_AA_AAA_AAAAAAA_PLANID INDEX 11484.4375
SPS_SZ IX_BB_BBB_BBBB_BBBBBB INDEX 13138.5
SPS_SZ TB_XX_XXXX_XXXX_XXX TABLE 38322
--索引加起来都要比表大
OWNER INDEX_NAME TABLE_NAME PAR UNIQUENES DEGREE INDEX_TYPE LEAF_BLOCKS BLEVEL CLUSTERING_FACTOR %
-------------------- ------------------------------ ------------------------------ --- --------- ---------- ---------- ----------- ---------- ----------------- ----------
SPS_SZ IX_AA_AAA_AAAAAAA TB_XX_XXXX_XXXX_XXX NO NONUNIQUE 1 NORMAL 284214 2 185996490 100
SPS_SZ IX_CC_CCC_CCCC_CCCCCC TB_XX_XXXX_XXXX_XXX NO NONUNIQUE 1 NORMAL 206567 2 6963531 .000006899
SPS_SZ IX_BB_BBB_BBBB_BBBBBB TB_XX_XXXX_XXXX_XXX NO NONUNIQUE 1 NORMAL 299483 2 6898441 .000049673
SPS_SZ IX_AA_AAA_ |