Microsoft SQL Server 2012 Performance Tuning Cookbook

Chapter 9. Implementing Indexes

In this chapter we will cover:

• Increasing performance by creating a clustered index
• Increasing performance by creating a non-clustered index
• Increasing performance by covering index
• Increasing performance by including columns in an index
• Improving performance by a filtered index
• Improving performance by a columnstore index

Introduction

Indexes are one of the most powerful objects in the RDBMS system, though the index itself is not a relational concept. It significantly reduces disk I/O and logical reads, to boost up the performance of the SELECT statement by locating proper data without even scanning the whole table. That is why it is mandatory to have a proper index on proper column(s) of the table. Missing indexes or ...