Let’s start with something simple – the Users table from Stack Overflow. You get just the clustered index of that table, and Brent gives you a few queries to execute. You’ll learn how to see the real database pages, understand why filtering isn’t necessarily expensive, but sorting data certainly is.

Demo Scripts

If you want to follow along with the demos, I’ll save you from the Herculean task of writing all those little queries down, heh:

 

29 Comments. Leave new

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}