Indexes and Statistics

  • Peter A Carter

Abstract

Recent versions of SQL Server support many different types of index that are used to enhance query performance. These include traditional clustered and nonclustered indexes, which are built on B-tree (balanced-tree) structures and enhance read performance on disk-based tables. There are also indexes that support complex data types, such as XML. DBAs can also create Columnstore indexes to support data warehouse–style queries, where analysis is performed on very large tables. SQL Server 2014 also introduces in-memory indexes, which enhance the performance of tables that are stored using In-Memory OLTP. This chapter discusses many of the available index types inside the Database Engine.

Keywords

Execution Plan Query Optimizer Leaf Level Data Page Base Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-0710-9_7_MOESM1_ESM.zip (12 kb)
Chapter 7.zip (zip 12 kb)

Copyright information

© Peter A Carter 2015

Authors and Affiliations

  • Peter A Carter
    • 1
  1. 1.BotleyUK

Personalised recommendations