Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition

CHAPTER
27	Columnstore Indices

In This Chapter

•   Benefits of Columnstore Indices

•   Internal Storage of Columnstore Indices

•   Types of Columnstore Indices

•   Editing Information Concerning Columnstore Indices

•   Columnstore Indices: Performance

As you already know from Chapter 10, index access means that indices are used to access entire rows that fulfill a condition of the given query. This is a general approach and doesn’t depend on the number of columns being returned. In other words, the values of all columns of a particular row will be fetched, even if values of only one or two columns are needed. The reason for this is that the Database Engine and all other relational database systems store a table’s rows on data pages, which ...