High Columstore index scan cost
Anyhow I have a table with 10 million rows with a clustered columnstore index on it. I am joining to it on 4 columns to return 1. It seems to be pulling back 9 million rows using an index scan but estimating 10k. Is there anything I can do to improve this, or is this expected when using a clustered columnstore index? First time using one.