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