oracle
-
编辑 删除
实例看反向索引的使用
wzf@TEST1> select * from t where x>5;已选择800行。Execution Plan---------------------------------------------------------- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=4994 Bytes=29964) 1 0 INDEX (FAST FULL SCAN) OF 'T_XY_REV' (NON-UNIQUE) (Cost=5 Card=4994 Bytes=2996 4)Statistics---------------------------------------------------------- 0 recursive calls 0 db block gets 68 consistent gets 9 physical reads 0 redo s
