O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required