SELECT messagein0_.proccnt AS col_0_0_ FROM mbfe.messagein messagein0_
WHERE messagein0_.msgID='ID:414d5120514d453333313020202020204c224a3c200c49cb';
1条记录
SQL_ID c1pvjs5wx132x, CHILD NUMBER 0
-------------------------------------
SELECT messagein0_.proccnt AS col_0_0_ FROM mbfe.messagein messagein0_
WHERE messagein0_.msgID=:1
PLAN HASH VALUE: 3093528534
-------------------------------------------------------------------------------
| ID | Operation | NAME | ROWS | Bytes | COST (%CPU)| TIME |
-------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 71102 (100)| |
|* 1 | TABLE ACCESS FULL| MESSAGEIN | 910K| 47M| 71102 (1)| 00:14:14 |
-------------------------------------------------------------------------------
Predicate Information (IDENTIFIED BY operation ID):
---------------------------------------------------
11g 搜集直方图导致不走索引
最新推荐文章于 2021-04-03 18:36:40 发布