Simple play icon Course

Designing and Implementing SQL Server Database Indexes

by Gail Shaw

This course is an introduction to SQL Server indexes. In this course, you will be covering common index types and discussing how to index to support your workloads.

What you'll learn

Poor database performance is a problem for applications and annoys users. Poor performance often comes down to poor indexing of critical tables. In this course, Designing and Implementing SQL Server Database Indexes, you'll gain knowledge on how to avoid these issues through the effective use of SQL Server database indexes. First, you'll discover the main index types that SQL Server has. Next, you'll explore considerations for their use. Finally, you'll learn how to choose indexes and index keys to best support your applications. When you've finished this course, you'll be in a good position to optimize all of your SQL Server databases and improve your applications' speed and throughput.

Table of contents

Course Overview
General Indexing Guidelines
Summary and Further Reading

About the author

Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She is a frequent poster on the SQL Server Central forums, writes articles for both and, and has spoken at SQL Saturday... more

Ready to upskill? Get started