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?