两中方法: 1.Explain plan explain plan for select * from aa; 查看结果: select * from table(dbms_xplan.display()); 2.Autotrace Set timing on --记录所用时间 Set autot trace --自动记录执行计划
忘了换行 - - 2.Autotrace Set timing on --记录所用时间 Set autot trace --自动记录执行计划
我按照楼上的使了一下,执行结果如下 PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | Pstart -------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 2202K| 2249M| 2595 | | 1 | PARTITION RANGE ALL | | | | | 1 | 2 | TABLE ACCESS FULL | TBL_MEMBER_INFO | 2202K| 2249M| 2595 | 1 -------------------------------------------------------------------------------- Note: cpu costing is off, 'PLAN_TABLE' is old version10 rows selected 你能帮我解释一下各个项都代表啥意思吗?谢谢!!
1.Explain plan
explain plan for
select * from aa;
查看结果:
select * from table(dbms_xplan.display()); 2.Autotrace Set timing on --记录所用时间
Set autot trace --自动记录执行计划
2.Autotrace
Set timing on --记录所用时间
Set autot trace --自动记录执行计划
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Pstart
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2202K| 2249M| 2595 |
| 1 | PARTITION RANGE ALL | | | | | 1
| 2 | TABLE ACCESS FULL | TBL_MEMBER_INFO | 2202K| 2249M| 2595 | 1
--------------------------------------------------------------------------------
Note: cpu costing is off, 'PLAN_TABLE' is old version10 rows selected
你能帮我解释一下各个项都代表啥意思吗?谢谢!!
读取行数 读取字节数 执行代价