You need to improve the performance of data warehouse queries. What should you do?

Columnstore indexes store data in a columnar format rather than row-based format, which is optimal for the large-scale aggregation and scan queries typical of data warehouse workloads. SQL Server uses batch-mode execution with columnstore indexes, processing thousands of rows at once and achieving significantly higher throughput. This makes them the standard recommendation for improving data warehouse query performance.

Clustered indexes are optimized for OLTP row-level lookups and point queries, not for the full-table scans and aggregations common in data warehouse queries.

Indexed views pre-aggregate specific query patterns but require exact query matching and do not provide the broad columnar storage and compression benefits needed for general data warehouse query acceleration.

Bitmap indexes are used in some database platforms like Oracle for low-cardinality columns, but SQL Server does not support bitmap indexes as a standalone index type, making this option invalid in this context.