Product has been added to your cart.

3.2 Indexing JSON for Faster Queries

There are two ways to do this: the SQL Server 2016-2022 way, and 2025’s new way with a native JSON datatype and native JSON index. I demo the differences between the two, and show why it’s probably best to stick with the 2016-2022 way of indexing it even if you’re on 2025 or newer.

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.

There are two ways to do this: the SQL Server 2016-2022 way, and 2025’s new way with a native JSON datatype and native JSON index. I demo the differences between the two, and show why it’s probably best to stick with the 2016-2022 way of indexing it even if you’re on 2025 or newer.

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.