3.1 Filtered Indexes, Indexed Views, Computed Columns, and Partitioning

Artisanal indexes should be your last resort – but you need to know the scenarios where they come in handy. In this module, you’ll learn how to recognize the symptoms where one of these specialized indexes can help, then learn whether you need to modify your code in order to get SQL Server to use…

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

Artisanal indexes should be your last resort – but you need to know the scenarios where they come in handy. In this module, you’ll learn how to recognize the symptoms where one of these specialized indexes can help, then learn whether you need to modify your code in order to get SQL Server to use...
To access this incredible, amazing content, you gotta get Live Class Season Pass or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu