Hacker News new | ask | show | jobs
by Femur 5934 days ago
That is not necessarily true. The 'last ditch' operation oracle will perform before a full-table scan is an index range-scan (very IO intensive compared with common index use).

There are MANY factors in play. Stats, parameters, histograms... it really depends.

1 comments

>That is not necessarily true. The 'last ditch' operation oracle will perform before a full-table scan is an index range-scan (very IO intensive compared with common index use).

Only if the index is covering.