From the course: Designing Database Solutions for SQL Server 2016

Unlock the full course today

Join today to access over 23,300 courses taught by industry experts.

Develop an indexing strategy

Develop an indexing strategy - SQL Server Tutorial

From the course: Designing Database Solutions for SQL Server 2016

Start my 1-month free trial Buy for my team

Develop an indexing strategy

“

- [Instructor] Creating an appropriate indexing strategy for your database is a key component to designing an efficient system. Indexing helps SQL Server retrieve information quickly from a data table by presorting the records in various ways. A clustered index is usually, but not always, included on the primary key for the table and it physically sorts the records on disk. Additional nonclustered indexes can be added to the table, which will sort records based on additional columns. These indexes will point back to the full data row in the clustered index for retrieval of the remaining table columns if they're required by a query. But adding indexes comes at a cost. Every time a data table is updated, indexes need to be updated and rebuilt. Knowing when to add additional indexes and on what columns and with which options is the key to assessing out a highly performing database. Here's a few guidelines to get started. Indexes should almost always be built on columns used as primary…

Contents