03 Designing Indexes for ORDER BY (23m)

Just like designing indexes for WHERE, this is another topic that seems simple on the outside, but unravels quickly. If your query only has equality searches in the WHERE, then the ORDER BY fields can just get added right onto the index keys, in…order. (See what I did there?) But if your query has INequality…

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.

Just like designing indexes for WHERE, this is another topic that seems simple on the outside, but unravels quickly. If your query only has equality searches in the WHERE, then the ORDER BY fields can just get added right onto the index keys, in…order. (See what I did there?) But if your query has INequality...
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":""}