本来除对主表FTS外,其它都是基于INDEX RANGE,ESTIMATE以后,全部变成了FTS。
但是实际SELECT速度却有所提高。BITI帮忙看一看,还要做些什么,再提高一些速度。特别是SQL。
第一次:未经过任何优化。
Statistics
--------------------------------------------------------
7 recursive calls
30 db block gets
19965 consistent gets
650 physical reads
1200 redo size
381 bytes sent via SQL*Net to client
503 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
4 sorts (memory)
4 sorts (disk)
1 rows processed
第二次:对表进行20 PERCENT的ESTIMATE;速度提高很多。
Statistics
--------------------------------------------------------
561 recursive calls
17 db block gets
426 consistent gets
0 physical reads
0 redo size
381 bytes sent via SQL*Net to client
50