Oracle11gR2 INDEX FAST FULL SCAN 成本计算
摘要:
SQL> select * from v$version where rownum create index i_test_owner on test(owner);Index created.INDEX FAST FULL SCAN只需要扫描叶子块,并且采用多块读,所以查询LEAF_BLOCK... 阅读全文
posted @ 2011-07-15 14:24 如果蜗牛有爱情 阅读(119) 评论(0) 推荐(0) 编辑