Fundamentals of Index Tuning

(8 customer reviews)


  • $0.00
Want a discount? Become a member by purchasing Live Class Season Pass or The Team Membership, or log in if you are a member.


You’re comfortable writing T-SQL queries, and now you want to make ’em faster – without changing the queries themselves.

In this one-day course, you’ll learn:

  • How to design indexes for a query without looking at its execution plan
  • How to pick the order of keys in an index
  • How query parameter values can change which index is better
  • Where to find index recommendations using query plans, DMVs, and sp_BlitzIndex
  • How SQL Server’s index recommendations are built, and why they’re often wrong

Note: this course does not cover columnstore, In-Memory OLTP, XML, or spatial indexes. (Nothing against those – they’re just beyond fundamentals.)


This is an online class – I (Brent) host it in GoToWebinar, live with me on webcam, taking questions as we go through the material together. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.

You can watch again later with Instant Replay – as soon as you buy the class, you can start watching the recordings, and keep watching for a year. Brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training with me, plus reminders. (Or, you can just buy the Instant Replay access – save money, and start watching your recordings immediately, streaming them in your browser for a year.)

Class dates & times:

8 reviews for Fundamentals of Index Tuning

  1. Joe McBratnie (verified owner)

    Learning and entertainment. Ok I am passionate about the subject. I learned a lot and will be able to put it into action with a little less stumbling. My role role is primarily operational but we to head more into the tuning side so this was a great fresher. And helps me use the consultant tool kit. Look forward to the next class.

  2. Ricardo Diaz (verified owner)

    Great class, great teacher! Brent knows the stuff inside out, and can explain it very naturally. And on top of that, he can sing too!!

    Thanks Brent! Looking forward to more.

  3. Marjorie Lancaster

    Very well done – learned a lot! The labs are especially helpful for understanding the material.

  4. Robin Forest (verified owner)

    Loved the class and how Brent presents it. He answers random questions without skipping a beat and the scripts being prewritten make it effortless to follow and pay attention to the details as Brent dives in. Would recommend to anyone who works with tsql!

  5. Shanmugam Senthivel

    Fantastic class! It is very hard to not to get bored on these subjects (for that matter any technical videos/blog post/books), but Brent keeps this interesting (who else can do it!).

    Sample database and lab queries are spot on, it will light fire for anyone to be better at performance tuning. You will feel confident when you have performance issues in your environment (what you can do and what you cannot do) .

  6. johntucker (verified owner)

    Great class, very happy I purchased. I had more than one “Aha!” moment. Brent takes time to answer questions as they come up while still maintaining a great pace. My only complaint is he doesn’t know how to pronounce “GIF”… IT’S LIKE JIFF FOR CRYING OUT LOUD!

  7. Greg Wahl (verified owner)

    Awesome class. Love the way you presented it.

  8. Charlie Arehart (verified owner)

    Another great addition to the stable of classes from Brent and company, this one bridges the gap between the free 90-minute “thinking like the engine” and the 3-day “mastering index tuning”.

    But be sure to read the prerequisites for the course, which include watching that very “thinking like the engine” course, as there are aspects of what’s discussed in this class that do presume you’ve heard what’s discussed there.

    And both classes presume you will have downloaded the StackOverflow database (which is a gig in size minimum). Since the class hits the ground running, you don’t to be trying to do that, as well as join the Slack group for the class, as it’s proceeding.

    With those admin details out of the way, you’re then off to the races with Brent as he helps you see and think through the implications of various index creation and tuning topics.

    Working with the real data of the SO database, in labs that you are to do at points through the day, you should be able to readily translate what you learn here into improvements in your own environment. Or you can proceed to the “mastering” class, if you want still more nuts and bolts, and more Ozar goodness. Maybe you’ll even earn an emoji or two in the slack channel during the class. 🙂

Add a review

Your email address will not be published. Required fields are marked *