Product has been added to your cart.

17 – Indexed Views (22m)

When your users frequently run aggregation queries on large amounts of data, and they’re willing to make delete/update/insert (DUI) operations slower in order to get faster reports, you should check out indexed views. Demo script: Transact-SQL /* Indexed Views v1.1 – 2019-04-09 Be aware that in here, you’re going to be making schema changes to…

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

When your users frequently run aggregation queries on large amounts of data, and they’re willing to make delete/update/insert (DUI) operations slower in order to get faster reports, you should check out indexed views. Demo script: Transact-SQL /* Indexed Views v1.1 – 2019-04-09 Be aware that in here, you’re going to be making schema changes to…

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