Over the weekend I read a paper titled Column-Stores For Wide and Sparse Data by Daniel J. Abadi. Below is a quick summary of the points made by Abadi followed by some thoughts / application for SQL Server’s ColumnStore index. Wide Tables & Column “Elimination” I’ve already discussed (in a previous post) why ColumnStores are […]
Tag: 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 […]
