December 18, 2013 at 3:33 pm
What is the exact benefit of column stored index in sql
December 18, 2013 at 4:02 pm
It's primarily used for heavy aggregation structures, such as warehouses. The problem is you can't update a table with that index attached, so it'd really only be useful on warehouse you do overnight updates to.
Columnstore Update Workarounds
It is however far too deep a discussion to randomly do over a forum post. If you want more information about it I recommend you start with the Technet article(s) on it and come back if you have particular questions you need help clarifying:
Technet Article on Columnstore
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 18, 2013 at 4:33 pm
There's a nice introduction to it[/url] over on Simple Talk.
SQL Server 2014 has updateable columnstore indexes.
"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
December 20, 2013 at 7:38 am
Thank you.
December 20, 2013 at 7:39 am
I got it. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply