04 Lab: Indexing for WHERE + ORDER BY (44m)

Now, it’s your turn: take the below queries individually and design the right nonclustered indexes to make them dramatically faster. For bonus points, you have a new challenge this time around: as you’re creating indexes to speed up queries, try to predict whether your execution plan will include a sort operator. As you work through…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Index Tuning, or log in if you already shelled out the cash.

Now, it’s your turn: take the below queries individually and design the right nonclustered indexes to make them dramatically faster. For bonus points, you have a new challenge this time around: as you’re creating indexes to speed up queries, try to predict whether your execution plan will include a sort operator. As you work through...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of Index Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}