How Index Keys & Includes Work (1 hour) Build your powers of index design by learning how indexes are structured in SQL Server. Modules Welcome Lessons Get ready to dive into indexing (3 minutes) Preview Download demo scripts and slides Learn Lessons Create a test index and discover its structure (8 minutes) Explore the index pages and their links (10 minutes) Update an important key value (9 minutes) Index structure, illustrated (3 minutes) Trace buffer latches on seeks and scans (16 minutes) Seeks and scans, illustrated (4 minutes) Quizzes and survey Lessons Three question video quiz Your “Final” Optional course survey
Learn Lessons Create a test index and discover its structure (8 minutes) Explore the index pages and their links (10 minutes) Update an important key value (9 minutes) Index structure, illustrated (3 minutes) Trace buffer latches on seeks and scans (16 minutes) Seeks and scans, illustrated (4 minutes)
