High Columstore index scan cost

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.

avatar image By JoshisOn 1 asked May 17, 2017 at 01:47 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: May 17, 2017 at 01:47 PM

Seen: 49 times

Last Updated: May 17, 2017 at 01:53 PM