August 25, 2015 at 12:58 pm
Hi,
I had an existing table with lots of indexes.
As a test (fro speed) - I added a non clustered column-store index.
When I run test queries it always ignores my new column-store index. Why?
Should I remove the old indexes, leaving just the column store?
August 25, 2015 at 3:36 pm
If it ignored the index, it's because it wasn't satisfying the queries. Columnstore indexes work best with aggregate style queries. They don't work at all well with point lookup or scan style queries. Depending on the type of queries you're running, you may see no improvement at all with a columnstore, or you may even see performance degrade. I would only add them where I think they were needed, not just on any old table.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 26, 2015 at 6:56 am
Thanks Grant
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply