|
Answer» Advantages of Column based tables:
- Calculations are typically executed on single or a few columns only.
- The table is searched based on values of a few columns.
- The table has a LARGE number of columns.
- The table has a large number of ROWS and columnar OPERATIONS are required (aggregate, scan, etc.).
- High compression rates can be achieved because the majority of the columns contain only a few distinct values (compared to a number of rows).
Advantages of Row-based tables:
- The application needs to only process a single RECORD at one time (many selects and/or updates of single records).
- The application typically needs to access a complete record (or row).
- The columns contain mainly distinct values so that the compression rate would be low.
- Neither aggregations nor fast searching is required.
- The table has a small number of rows (e. G. configuration tables).
Advantages of Column based tables: Advantages of Row-based tables:
|
