This is a dedicated watch page for a single video.
One of the key benefits to columnstore indexes is the ability to compress your data. In addition to columnstore compression, SQL Server offers a few other options for compressing data. While SQL Server still stores compressed data on 8 KB pages, when the data is compressed, more rows of data can be stored on a given page, which allows the query to read fewer pages. Which of the below is a negative tradeoff to the benefits of using data compression in SQL Server?