Hands-On-Lab: SQL Server Non-Clustered Index Internals

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Non-Clustered Index Internals.

In this lab, we will clear our understanding on non-clustered index. This lab is divided into multiple exercises and in each exercise, we will cover different aspects of the non-clustered index. In the first exercise, we will look at the B-Tree structure of the non-clustered index, we will also look at pages at a different level of the non-clustered index. In the second exercise, we will look at non-clustered index over a heap and we will also explore RID LOOKUP. In the third exercise, we will look at non-clustered index over a clustered index and the concept of key/bookmark lookup. And in fourth and last exercise of this lab, we will cover a select query to minimize I/O with a non-clustered covering index.

Exercise 1: Understanding Non-Clustered Index B-Tree Structure
Exercise 2: Non-Clustered Index on Heap
Exercise 3: Non-Clustered Index over Clustered Index
Exercise 4: Covering Index

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.