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?