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.
By JoshisOn 1 asked May 17, 2017 at 01:47 PM