Column store indexes

          Column store index is awesome feature in SQL server 2012. You can get this feature expand the any one table you can see Index. Then right click on the indexes folder you can see “Non-Clustered Column store Index” , as shown in the below figure.

             Normally when we create an Index on table it store the records on page as row wise and each page have 8KB Size. For example I create an index on CountryMaster table, after that if I query country column from the CountryMaster table it fetch the record from all the pages and give it into us. See the image bellow

Now let see how Non-Clustered Column store Index work. Non-Clustered Column store Index stored the records based on column wise it store same column data on same page. If I stored data as column wise then we avoid fetch data from multiple page. See image bellow