2011-11-08Clustered Indexes and Index-Organized Tables

The previous installment explained the index-only scan to prevent the table access after an index lookup.

Todays update extends the idea and elaborates on the question if the separate table structure is required at all, if the index covers all table columns.

Continue Reading