我在Oracle中怎么样才能将下面的查询打印出来,高手请进........
我主要的目的是想将一个SQL语句在ORACLE中是否进行索引优化处理了!!
比如:
select * from a where a = '1';
在这里a是索引,我怎么样将它在ORACLE中是否用到索引了!!
下面的话打印出来,在我执行完SQL语句以后,
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=3132 Card=318474 Byt es=141402456)
1 0 TABLE ACCESS (FULL) OF 'MYTABLES' (Cost=3132 Card=318474 Byt es=141402456)
Statistics
----------------------------------------------------------
7 recursive calls
89 db block gets
41473 consistent gets
19828 physical reads
0 redo size
131489563 bytes sent via SQL*Net to client
1760245 bytes received via SQL*Net from client
21729 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
325917 rows processed