Hi @oripsk, When you query a table clustered by columns (a, b, c) and filter on (b, c), the query will not fully benefit from the clustering optimization. Clustering works best when the query filter includes the leading column(s) in the clustering order. In your case, since the filter does not include column ‘a’, the optimization benefits will be limited.
For optimal performance, it’s recommended to include the first clustered column in your query filter. This allows the query engine to effectively use the clustered index to reduce the amount of data scanned.
Is there a specific use case or dataset you’re working with that you’d like more advice on?
