Get Your ColumnScore You're thinking about using Microsoft SQL Server's columnstore indexes to make your queries go faster. Are they a good fit? Take this one-page test to find out! Think about just one of your tables - the one you're most likely to use columnstore indexes on - as you answer these questions: Number of rows in the table:*Under 1,000,0001-10 Million10 Million to 100 Million100 Million to 1 BillionOver 1 BillionThe table's size on disk:*Under 10 GB10-100GB100-1,000GBOver 1 terabyteNumber of columns in the table:*1-1011-25Over 25We have one column we usually filter by, like SalesDate:*NoYesTo load the data, we:*Insert data less than 10,000 rows at a time (like INSERT VALUES)Insert 10,000-100,000 rows in a single statementInsert 100,000-1,000,000 rows in a single statementInsert over 1,000,000 rows at a timeTo update the data, we:*Never update itDelete the original rows and reload new onesUse the UPDATE statementTo delete data, we:*Never delete itDelete a million or more rows with one DELETE statementDelete less than 1,000,000 rows at a timeTable name (optional)On the next screen, we're going to show the score for this table. If you want to print it out or take a screenshot, this will help if you're deciding about columnstore indexes for several different tables.
