Does delete rows improve index range scan performance?
698658May 9 2011 — edited May 10 2011Hi,
let say I'm on 9.2.0.8 and got table with few indexes .
Now I delete 90% rows and DO NOT rebuild table indexes nor coalesce indexes .
In that case does index range scans using queries perform faster (less i/o) ?
Please explain Your answer .
Regards
GregG