"Heavier Options When the Query Is Genuinely Expensive"

1. What is a primary requirement for creating an indexed view in SQL Server?

Having no outer joins Including a non-clustered index Using only simple calculations Requiring a table with a primary key

2. What is a significant drawback of using an indexed view?

High storage costs Requires more complex queries Increases write path impact on OLTP Reduces read performance

3. What is the main advantage of using a pre-aggregated reporting table as opposed to an indexed view?

It requires less storage space It refreshes automatically It does not impact OLTP write performance It allows for more complex queries

4. Which option involves separating reporting work from the transactional workload in SQL Server?

Readable secondary Indexed view Pre-aggregated table Columnstore index