Product has been added to your cart.

3.3 Using the Second Column of an Index with Skip Scans

Normally, to get the most bang for your buck from an index, your query needs to either do a seek on the first column in the index, or we need to leverage its sorting somehow, like a TOP combined with an ORDER BY. But what if the first column has very few distinct values, and…

To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

Normally, to get the most bang for your buck from an index, your query needs to either do a seek on the first column in the index, or we need to leverage its sorting somehow, like a TOP combined with an ORDER BY. But what if the first column has very few distinct values, and…

To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.