Purpose of Columnstore Index in SQL Server 2012

ByHariharan Rajendran

Purpose of Columnstore Index in SQL Server 2012

Nowadays, data being generated and captured across many devices, applications and services. Now every organization is tasked with storing massive amounts of data to accelerate their business growth success.

Using traditional tools to capture and process the data is very challenging and it is not going to be one time activity because all data users want to see continuous growth.

We have below issues while doing this task.

  1. The Volume of data is high, so the ability of data warehouses to execute the queries within a time is not achievable.
  2. More time is required to Tune the queries.
  3. Designing and maintaining multiple indexes.

In many cases, so much of time elapsed between the time the query start executed and time to render the result.

To overcome the above issues, Microsoft SQL Server team worked on columnstore Index, which allow very large data set to be read quickly.

The performance of the columnstore index is far better than normal index. This has been introduced in Microsoft SQL Server 2012.

About the Author

Hariharan Rajendran author

Hariharan Rajendran is a Microsoft Certified Trainer with 9+ years of experience in Database, BI and Azure platforms. Hariharan is also an active community leader, speaker & organizer and leads the Microsoft PUG (Power BI User Group – Chennai), SQLPASS Power BI Local Group – Chennai and an active speaker in SQL Server Chennai User Group and also a leader in Data Awareness Program worldwide events. Hariharan also frequently blogs (www.dataap.org/blog), provides virtual training (on ad-hoc basis) on Microsoft Azure, Database Administration, Power BI and database development to worldwide clients/audience.

Comments Are Closed!!!