Thanks for the great reply.

Thanks for the detailed reply. Makes sense now.

Indulge me, I am being simplistic here. So, If I am doing a scan on a range on an indexed column.

Non-Clustered Index.

1. Relevant...

I thought non-clustered index had the RIDs of the actual rows, whereas clustered index stored the actual row as leaf nodes. It is precisely because of physical ordering that we...