Database Administration (MOSC)

MOSC Banner

When is row index and full table scan done exactly???

edited Aug 27, 2013 9:07PM in Database Administration (MOSC) 9 commentsAnswered
i have a table with 1lacs record and when i perform a delete on 60thousand record it does a index scan and even after that if i fire any select query on even rest of the records it always shows a index scan
whereas oracle docs says if the number of rows being fetched is more
 then 15-20% of the total number of rows it does a full table scan

so why does it not do the full table scan i have a normal index created on the table


i have also tried alter session set optimizer_index_caching=0; (suggested to me bt didnt help)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center