SQL Server, columnstore indexes: A bit of theory and some examples (when to use columnstore indexes and when not)
Hi guys, Today we speak about columnstore index . I wrote a summary, a list of things to know about and some examples in order to learn how to use (or not) this types of indexes. Are you Ready? Yes! What is a columstore index Yes but what is a columnstore index? Microsoft introduced, in SQL Server, Columnstore indexes that are the standard for storing and querying large tables, let's think to tables with million of records. The difference is that data is stored inside page in a different way . In a row-based index data is stored in one or more data pages. In a column-based index data is stored in a separate pages for each column of the table. A columnstore is data that's logically organized as a table with rows and columns, and physically stored in a column-wise data format. A rowstore is data that's logically organized as a table with rows and columns, and physically stored in a row-wise data format. Just as there are clustered and ...