Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index Full scan

Sekar_BLUE4EVERJan 7 2015 — edited Jan 8 2015

Hi Guys,     I want to know how a Index Full Scan works in detail.Does it  always scan from first leaf block to last leaf block(all blocks) in the index irrespective of the where condition i.e even though I have only one row satisfying the condition does it scan all the blocks of index?

This post has been answered by John Stegeman on Jan 7 2015
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 5 2015
Added on Jan 7 2015
31 comments
8,582 views