Question
When can an indexed view improve warehouse query performance?
Select an option. Your answer will be checked instantly.
Correct Answer: B. When it materializes a frequently reused deterministic aggregation or join
Explanation:
An indexed view stores its result physically and can avoid repeated computation.
Its maintenance cost and SQL Server restrictions must be evaluated carefully.
Leave a Reply