ColumnStores vs. RowStores: I/O Performance and Compression

One of the major benefits associated with ColumnStore¬† indexes is increased I/O performance.¬† Below are two of the more common explanations for this bump in I/O performance… ColumnStores only retrieve data¬†(from storage) necessary to satisfy the query This notion is inherent in the column-oriented architecture…data pages in column-oriented storage only contain data from a single …

Continue reading