ColumnStore Index in SQL

Hi Friends,

Non-Clustered Column store index introduced in SQL 2012:
-> if table have Non-Clustered Column store index , then its read only, can not modify the data.
-> but non clusted column index gives more performace for retriving data
->Data stored in column format interanally

Clustered Column store index introduced in SQL 2014:
->if table have Clustered Column store index, can insert , update,Delete  data as like normal index.
-> if table have Clusted column store index , can not create other index

Below is good article for Clustred Column store index

http://aboutsqlserver.com/2014/05/06/clustered-columnstore-indexes-exploring-delta-store-and-delete-bitmap/

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s