A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned.
How should this query be optimized?
A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned.
How should this query be optimized?
Correct
Adding a clustering key would improve the depth and, in turn, pruning efficiency.