Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A query with a WHERE clause is performing slower than anticipated. The Query Profile indicates that all micro-partitions are being scanned.
How can this query be optimized?
A
Create a view on the table.
B
Add a clustering key to the table.
C
Add a LIMIT clause to the query.
D
Add a Dynamic Data Masking policy to the table.