Home > SQL Denali > Columnstore Indexes

Columnstore Indexes


 

Column Store index in a revolutionary feature in the database world. Microsoft has included this indexing technique in the upcoming of SQL Server code name “Denali”

It is mainly design to accelerate the data warehouse queries. The proven experiment shows that the performance of query in the data warehouse environment has improved by 100 to 1000 times.

It differs from the normal B-Tree or Heap indexes. The differences between the current and the future indexes feature is shown in this diagram.

This features utilize the Vertipaq technology. Compression and store method of the feature improves IO performance in large-scale. So, It retrieves the large amount of data without any overhead.

There are plenty of details available in the document. I would suggest the reader to  Download the document and be the first person to learn about the new exciting feature in “Denali”.

Thanks for reading. Visit Facebook page SQLServerRider.com for more latest note about SQL Server.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: