Expert Performance Indexing in SQL Server, Second Edition

Contents

About the Authors

About the Technical Reviewer

Introduction

 Chapter 1: Index Fundamentals

Why Build Indexes?

Major Index Types

Heap Tables

Clustered Indexes

Nonclustered Indexes

Columnstore Indexes

Other Index Types

XML Indexes

Spatial Indexes

Hash and Range Indexes

Full-Text Search

Index Variations

Primary Key

Unique Index

Included Columns

Partitioned Indexes

Filtered Indexes

Compression and Indexing

Index Data Definition Language

Creating an Index

Altering an Index

Dropping an Index

Index Metadata

sys.indexes

sys.index_columns

sys.xml:indexes

sys.selective_xml:index_paths

sys.spatial_indexes

sys.column_store_dictionaries

sys.column_store_segments ...