What the key facts to choose Row Store and Column Store

Row Store: if you want to report on all the columns then the row store is more suitable because reconstructing the complete row is one of the most expensive column store operations.

Column Store: if you want to fill the table with huge amounts of data, that should be aggregated and analysed then a column store is more suitable.