The Perfect Index

Target Audience:

Database Administrators or Developers who want to create useful and thoughtfully designed indexes

Abstract:

Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It’s not easy to form indexes for a large and complicated query, and things only get more complicated when queries can come from vendor applications, ORM tools like LINQ, or any number of other sources.

When it’s time to create the perfect index, there’s guidelines and strategies to get it right, and then prove that it’s helping. However, performance is not always about just one index, and general index strategy can also achieve great results. We’ll focus on how to get the perfect index or indexes for your workload.

Why I Want to Present This Session:

I love the power of a good index in improving performance, but I see a lot of controversy over what the right index is.