Understanding Row and Column store

Which of the given statements regarding Row and Column store can be considered true?

  1. Row store is that every end of row set contains the pointer to the starting of the next row and in column store, data is stored in adjacent memory positions.
  2. Column based storage is beneficial for small database and row store is encourages in large database
  3. Higher compression can be achieved in row store and in column store no aggregation functions can be obtained.
  4. None of these

Related Posts