Why Did My Clever Index Change Backfire? (Preview)

Speaker: Kendra Little

Duration: 60 minutes

Track: Build

SQL Server is full of advanced techniques to build powerful indexes: indexed views, filtered indexes, columnstore indexes, and more. But many of these techniques have risks: your cool indexing idea may backfire and leave your users frustrated. In this preview session, you'll see a few demos of how different indexing patterns may slow down queries, have dangerous side effects, or not work at all. If you have a solid knowledge of index basics and are comfortable reading query execution plans, this session will improve your index tuning skills.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.

cage-aids
cage-aids
cage-aids
cage-aids