Data is not physically ordered in index, only logical order is maintained through slot array

http://blog.waynesheffield.com/wayne/archive/2012/10/does-a-clustered-index-really-physically-store-the-rows-in-key-order/
http://sqlinthewild.co.za/index.php/2015/10/20/of-clustered-indexes-and-ordering/

http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-proof-that-records-are-not-always-physically-stored-in-index-key-order/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s