High Columstore index scan cost

JoshisOn 2017-05-17 13:47:31

First time using the post to sql performance from sql sentry.

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.