2016 | OriginalPaper | Chapter
7. Designing and Tuning the Indexes
Published in:
Pro SQL Server Internals
Abstract
It is impossible to define an indexing strategy that will work everywhere. Every system is unique and requires its own indexing approach based on workload, business requirements, and quite a few other factors. However, there are several design considerations and guidelines that can be applied in every system.