|
Answer» There are six types of base tables in the DB2 database:- - Regular Tables: General purpose tables and Common tables with the indexes are known as the general purpose tables.
- Multidimensional Clustering Table (MDC): This TYPE of table is used to maintain large database environments.
- Insert TIME clustering Table (ITC): They can be partitioned tables.
- Range-Clustered tables Table (RCT): This type of table provides fast and direct access to data.
- Partitioned Tables: These type of tables are used in the data organization schema where the table data is divided into MULTIPLE storage objects.
- Temporal Tables: History of a table in a database is stored in a TEMPORARY table like the details of the MODIFICATIONS done previously.
|
