查看sql的执行计划

最新推荐文章于 2024-09-09 00:34:51 发布
lyfhehe
最新推荐文章于 2024-09-09 00:34:51 发布
阅读量162
点赞数
分类专栏： oracle database
本文链接：https://blog.csdn.net/lyfhehe/article/details/105223937
版权
oracle database 专栏收录该内容
15 篇文章 0 订阅
订阅专栏
SQL> set autotrace traceonly explain;
SQL> select count(*) from AP.AP_CHECKS_ALL#;

Execution Plan
----------------------------------------------------------
Plan hash value: 2507571169

-------------------------------------------------------------------------
| Id  | Operation        | Name         | Rows  | Cost (%CPU)| Time     |
-------------------------------------------------------------------------
|   0 | SELECT STATEMENT |              |     1 |    99   (2)| 00:00:01 |
|   1 |  SORT AGGREGATE  |              |     1 |            |          |
|   2 |   INDEX FULL SCAN| AP_CHECKS_N4 | 33055 |    99   (2)| 00:00:01 |
-------------------------------------------------------------------------

SQL> select count(*) from  apps.AP_CHECKS;

Execution Plan
----------------------------------------------------------
Plan hash value: 2769988729

--------------------------------------------------------------------------
| Id  | Operation         | Name         | Rows  | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |              |     1 |     0   (0)|          |
|   1 |  SORT AGGREGATE   |              |     1 |            |          |
|*  2 |   FILTER          |              |       |            |          |
|   3 |    INDEX FULL SCAN| AP_CHECKS_N4 | 33055 |    99   (2)| 00:00:01 |
--------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter(NULL IS NOT NULL)

SQL> select * from  AP.AP_CHECKS_ALL#;

Execution Plan
----------------------------------------------------------
Plan hash value: 549637158

--------------------------------------------------------------------------------
---

| Id  | Operation         | Name          | Rows  | Bytes | Cost (%CPU)| Time
  |

--------------------------------------------------------------------------------
---

|   0 | SELECT STATEMENT  |               | 33055 |    10M|   531   (3)| 00:00:0
1 |

|   1 |  TABLE ACCESS FULL| AP_CHECKS_ALL | 33055 |    10M|   531   (3)| 00:00:0
1 |

--------------------------------------------------------------------------------
---


SQL> select * from apps.AP_CHECKS;

Execution Plan
----------------------------------------------------------
Plan hash value: 2927437457

--------------------------------------------------------------------------------
----

| Id  | Operation          | Name          | Rows  | Bytes | Cost (%CPU)| Time
   |

--------------------------------------------------------------------------------
----

|   0 | SELECT STATEMENT   |               |     1 |   325 |     0   (0)|
   |

|*  1 |  FILTER            |               |       |       |            |
   |

|   2 |   TABLE ACCESS FULL| AP_CHECKS_ALL | 33055 |    10M|   531   (3)| 00:00:
01 |

--------------------------------------------------------------------------------
----


Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(NULL IS NOT NULL)

SQL> select * from apps.AP_CHECKS where amount='90000'
  2  ;

Execution Plan
----------------------------------------------------------
Plan hash value: 2927437457

--------------------------------------------------------------------------------
----

| Id  | Operation          | Name          | Rows  | Bytes | Cost (%CPU)| Time
   |

--------------------------------------------------------------------------------
----

|   0 | SELECT STATEMENT   |               |     1 |   325 |     0   (0)|
   |

|*  1 |  FILTER            |               |       |       |            |
   |

|*  2 |   TABLE ACCESS FULL| AP_CHECKS_ALL |     3 |   975 |   518   (1)| 00:00:
01 |

--------------------------------------------------------------------------------
----


Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(NULL IS NOT NULL)
   2 - filter("AMOUNT"=90000)

SQL> select * from AP.AP_CHECKS_ALL# where amount='90000'
  2  ;

Execution Plan
----------------------------------------------------------
Plan hash value: 549637158

--------------------------------------------------------------------------------
---

| Id  | Operation         | Name          | Rows  | Bytes | Cost (%CPU)| Time
  |

--------------------------------------------------------------------------------
---

|   0 | SELECT STATEMENT  |               |     3 |   975 |   518   (1)| 00:00:0
1 |

|*  1 |  TABLE ACCESS FULL| AP_CHECKS_ALL |     3 |   975 |   518   (1)| 00:00:0
1 |

--------------------------------------------------------------------------------
---


Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("AMOUNT"=90000)

SQL>