Database Indexing for Performance Public Class

About the Class

*DB Indexing for Performance* • What is Index? • Index B Tree • Index Types o Clustered o Non Clustered o Composite index o Covering index • Index Design • Indexing Strategy • Index Selection Precaution • Examine detailed topics in query optimization • Indexes with SARGs • Improvised SARGs • Clustered vs. Non Clustered indexes • Queries with OR • Index covering • Forcing index selection

Language of instruction:

Keywords: database indexing, clustered, non clustered, composite index, covering index