Performance Tuning: Index Optimization

Speaker(s)Konstantin Melamud

Duration: 60 minutes

Track: Enterprise Database Administration & Deployment

As our data size grows larger the need for optimal indexing within our databases becomes even more important than before. This session will help you understand how choose appropriate indexes to streamline our DML operations in our enterprise.  You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules. 

Accompanying Materials:

No material found.

Back to Top