Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 6, 2017
Indexes are essential to good database performance, but it can be hard to decide what indexes to create and the ‘rules’ around indexes often appear to be vague or downright contradictory.
In this session we’ll dive deep into indexes, have a look at their architecture and internal structure and how that affects the way that indexes are used in query execution. We’ll look at why clustered indexes are recommended on almost all tables and how their architecture affects the choice of columns. We’ll look at nonclustered indexes; their architecture and how query design affects what indexes should be created to support various queries.
Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization. She works for Entelect, a medium-sized custom software development house. Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server.