Index Vocabulary, Structure, and ConceptsHeapsClustered IndexesNonclustered IndexesStructure of Indexes and the HeapIndexes Created by ConstraintsOther Ways to Categorize IndexesOther Index Concepts and TerminologyCreating Indexes via T-SQLCreating Clustered and Nonclustered IndexesCreating Unique and Primary Key IndexesCreating Filtered IndexesCreating XML IndexesCreating Indexes Using the GUICreating an Example TableCreating a Clustered Index via the GUICreating a Nonclustered Index via the GUIPost-Index CreationPerformance of Insert, Update, and Delete StatementsUseful Dynamic Management ViewsPutting It All TogetherSetting Up the ScenarioTable ScansClustered Index SeeksCovering Your QueriesIndexing JOIN CriteriaFiltered IndexesSummary