What is the functional difference between Row and Column based storage

What is the functional difference between Row and Column based storage? Where do we use Row based storage and column based storage?

Answer»

Consider below table- FCTSales

Row Based Storage −

Column Based Storage −

Where to use Row based storage?

Select * from FCTSales where Country=’US’

Where to use Column based storage?

Select SUM(Units_sold) from FCTSales where Product=’Lenovo A110’