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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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