Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
In the context of Azure SQL Data Warehouse, describe how you would tune a query by using indexers to improve its performance. Provide a detailed explanation of the types of indexers that can be used and how they affect the query execution plan.
A
Use clustered columnstore indexes for all tables without considering query specifics.
B
Analyze query patterns and use appropriate index types such as clustered indexes or non-clustered indexes tailored to the query's access patterns.
C
Create a single index for the primary key and use it for all queries.
D
Do not use indexers as they are not effective in improving query performance.
