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?
