5.6 Designing a data DB area
A data DB area consists of segments and pages. To improve the efficiency of data storage, it is important to design a page size based on appropriate factors, because the segment size is set automatically on the basis of the page size.
An inappropriate page size will result in poor data access efficiency and degraded performance.
Consider the following points when designing a data DB area:
-
The number of tables (indexes) that will be stored and the data DB areas in which they will be stored
-
The number of data DB area files that will make up one data DB area
-
Whether to store multi-chunk tables in the data DB area
-
Whether to store both column store tables and row store tables in the same data DB area
-
The size of each page
Details regarding these points are explained in the following sections:
- Note
-
Once you have designed the page size, estimate the size of the data DB area. For details about how to estimate the size of the data DB area, see 5.8 Estimating the size of the data DB area.