Go through my previous article here, about Data storage format in columnstore Index.
There are lots of improvements in Query processing speed when we use columnstore Index.
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.
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.