在查看SQL语句执行计划时 , 在Sqlplus下使用set autot traceonly
set longsize 800
set autot traceonly
select">test@ora10g>select * from t_test where tonecode like '501%';
已选择5103行。
执行计划
----------------------------------------------------------
--------------------------------------------------------------------------------
--
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)|
--------------------------------------------------------------------------------
--
| 0 | SELECT STATEMENT | | 5116 | 2333K| 76
(0)|
| 1 | TABLE ACCESS BY INDEX ROWID| T_TEST | 5116 | 2333K| 76
(0)|
|* 2 | INDEX RANGE SCAN | PK_TEST | 5116 | | 32
(0)|
--------------------------------------------------------------------------------
--
... ...
在pl/sql developer选中语句使用F5 , 输出
SELECT STATEMENT, GOAL = ALL_ROWS Cost=76 Cardinality=5116
Bytes=2389172
TABLE ACCESS BY INDEX ROWID Object name=t_test Cost=76 Cardinality=5116
Bytes=2389172
INDEX RANGE SCAN Object name=pk_test Cost=32 Cardinality=5116
两边输出结果一致 。 可见在进行该操作时 , pl/sql developer F5还是蛮方便的。[@more@]
set longsize 800
set autot traceonly
select">test@ora10g>select * from t_test where tonecode like '501%';
已选择5103行。
执行计划
----------------------------------------------------------
--------------------------------------------------------------------------------
--
| Id | Operation | Name | Rows | Bytes | Cost
(%CPU)|
--------------------------------------------------------------------------------
--
| 0 | SELECT STATEMENT | | 5116 | 2333K| 76
(0)|
| 1 | TABLE ACCESS BY INDEX ROWID| T_TEST | 5116 | 2333K| 76
(0)|
|* 2 | INDEX RANGE SCAN | PK_TEST | 5116 | | 32
(0)|
--------------------------------------------------------------------------------
--
... ...
在pl/sql developer选中语句使用F5 , 输出
SELECT STATEMENT, GOAL = ALL_ROWS Cost=76 Cardinality=5116
Bytes=2389172
TABLE ACCESS BY INDEX ROWID Object name=t_test Cost=76 Cardinality=5116
Bytes=2389172
INDEX RANGE SCAN Object name=pk_test Cost=32 Cardinality=5116
两边输出结果一致 。 可见在进行该操作时 , pl/sql developer F5还是蛮方便的。[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-971533/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-971533/