Kedhar Natekar continues a series on Snowflake performance:
Clustering does not guarantee improved performance on non-clustered columns.
If you have frequent queries on non-clustered columns and performance is the key irrespective of cost, then opt for a search optimization service over the entire table of specific columns.
It’s similar to enabling indexing on RDBMS databases like Oracle on specific columns.
Read on to see how these work and get a few tips along the way.