From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Manage indexes and data maintenance

Manage indexes and data maintenance - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Manage indexes and data maintenance

“

- [Instructor] In this video we'll discuss the purpose and use of indexes in a SQL server database. An index is essentially an on-disk structure, that is associated with a table or a view. And it helps to speed the retrieval of rows from that table to review. In order to do so it contains keys that are built from typically one or more columns, within the table or the view itself. Now, these keys are stored in a structure, typically a B-tree, that enables SQL Server to actually find the rows, and associated data with the keys, quickly and efficiently. Now, SQL Server supports a few different types of indexes. So, let's take a look at those. Looking on the MSDN page for the indexes for SQL Server 2016 we can see a number of indexes that are available, such as the Hash, Clustered, Nonclustered, Unique and Columnstore. Typically you'll spend your time focused on creating clustered and nonclustered indexes. So read through these descriptions to get an understanding of how these types of…

Contents