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.

Organization of this section

• 5.6.1 Points to consider when designing a data DB area

• 5.6.2 Points to consider in storing a multi-chunk table in the data DB area

• 5.6.3 Points to consider when determining the page size in data DB areas

To Page Top