当前位置: 代码迷 >> Oracle开发 >> sql优化 consistent gets与cost解决思路
  详细解决方案

sql优化 consistent gets与cost解决思路

热度:42   发布时间:2016-04-24 06:55:28.0
sql优化 consistent gets与cost
执行计划
----------------------
Plan hash value: 2241963146

-------------------------------------------------------------------------
| Id  | Operation                        | Name                     | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------
|   0 | SELECT STATEMENT                 |                          |     1 |   142 |    22   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE                  |                          |     1 |   142 |            |       |
|   2 |   NESTED LOOPS                   |                          |     1 |   142 |    22   (0)| 00:00:01 |
|   3 |    NESTED LOOPS                  |                          |     1 |   111 |    20   (0)| 00:00:01 |
|   4 |     NESTED LOOPS                 |                          |     1 |    88 |    19   (0)| 00:00:01 |
  相关解决方案