2.1.1 Base tables
A base table is a table that contains data that is actually stored in a database.
The two basic types of base tables are row store tables and column store tables, each of which stores data in a different format. These tables can be further categorized into single-chunk tables in which only one chunk can be created, and multi-chunk tables in which multiple chunks can be created. When defining a base table, you select whether to define it as a row store table or column store table, and also whether to make it a single or multi-chunk table. This means that a base table you define will be one of the following types:
-
Single-chunk row store table
-
Multi-chunk row store table
-
Single-chunk column store table
-
Multi-chunk column store table
For details about the features of row store tables, column store tables, single-chunk tables, and multi-chunk tables, see 2.2 Base table types.