Question
Why should a warehouse not create an index for every possible query?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Indexes consume storage and slow loads and maintenance
Explanation:
Each index must be stored and updated when data changes.
Designers balance query benefits against ETL, storage, and maintenance costs.
Leave a Reply