1 Plan hash value: 1138811981
2
3 ----------------------------------------------------------------------------------------------
4 | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
5 ----------------------------------------------------------------------------------------------
6 | 0 | SELECT STATEMENT | | 1132K| 725M| | 185K (1)| 00:37:10 |
7 | 1 | SORT ORDER BY | | 1132K| 725M| 1608M| 185K (1)| 00:37:10 |
8 |* 2 | TABLE ACCESS FULL| MMS_SWFINFO0001 | 1132K| 725M| | 24884 (1)| 00:04:59 |
9 ----------------------------------------------------------------------------------------------
10
11 Predicate Information (identified by operation id):
12 ---------------------------------------------------
13
14 2 - filter("TXTID"='TRAN,MMS_SWFINFO0001,MMS_SWFINFO,B4,SWFO201808090002')
oracle 收集直方图不走索引
最新推荐文章于 2023-07-06 15:40:45 发布