From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Basics of indexes - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Basics of indexes
- [Narrator] In this section, we're going to talk about indexes in SQL Server 2016. An index is a copy of information from a table, an index is smaller than a table, and indexes can be presorted. These characteristics of being smaller than a table and being presorted allow us to search indexes more quickly. So when we need to search for information in a particular column on SQL Server, if that column has an index, the machine can choose to search the index rather than search the table. Because the index is smaller, it can be searched faster, and because it's already sorted, it can be searched faster. So for example if we're searching for some text that starts with the letter z, the machine would be smart enough to start at the bottom of the index knowing that's where the zs are going to be. SQL Server 2016 supports a number of types of indexes. We have clustered, nonclustered, columnstore, spatial, XML, and full-text indexes. We'll talk about each one of these individually. A…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.