Chapter 6. Building and maintaining indexes
After completing this chapter, you will be able to
Understand the structure of an index.
Understand the different types of indexes.
Create different types of indexes.
Add included columns and filters to an index.
Place an index in a filegroup.
Disable and drop an index.
An index is an on-disk data structure that is based on tables and views. Indexes make the retrieval of data faster and efficient, in most cases. However, overloading a table or view with indexes could adversely affect the performance of other operations such as inserts or updates.
In this chapter, you will be introduced to the basic structure of clustered, nonclustered, and columnstore indexes, and you will learn the differences between each ...
Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
