Sample Header Ad - 728x90

When would a columnstore index be unsuitable for an OLAP environment with large and wide tables?

0 votes
2 answers
126 views
Suppose that your SQL Server 2019 machine has a query that hits a disk-based table that is both long (let's say 3,000,000 rows) and wide (let's say 150 columns). Suppose that you retrieve most of the rows and most of the columns. Finally, suppose that the table is infrequently changed. Consider it a typical reporting server table that is only updated once a day. **Are there any circumstances at all where the above conditions apply and a traditional rowstore index would be preferable to a columnstore index, clustered or otherwise?** I worry that I have been sold too easily on columnstore indexes and will begin using them on all of my large and wide tables.
Asked by J. Mini (1237 rep)
Jun 22, 2024, 08:29 PM
Last activity: Jun 22, 2024, 11:41 PM