In the previous chapter, I introduced the core indexes within SQL Server, both rowstore and columnstore, clustered and nonclustered. This chapter takes that information and describes additional functionality related to indexes. I’ll also introduce some new indexes in this chapter. There are a number of index settings that affect their behavior, which we’ll discuss.