Versions available for this page: CUBRID 8.4.3 | CUBRID 9.0.0 |
Partitioning is a method by which a table is divided into multiple independent logical units. Each logical unit used in partitioning is called a partition. Partitioning can enhance manageability, performance and availability. Some advantages of partitioning are as follows:
Three types of partitioning methods are supported by CUBRID: range partitioning, hash partitioning, and list partitioning.
The maximum number of partitions cannot exceed 1,024. Each partition of a table is created as its subtable. The subtables created by the partitioning process cannot be altered or deleted by users. The name of the subtable is stored in the system table in a 'class_name__p__partition_name' format. Database users can check the partitioning information in the db_class and db_partition virtual tables. They can also check the information by using the ;sc <table name> command in the CUBRID Manager or the CSQL Interpreter.
The data types of columns allowed as partitioning expressions are as follows:
The following shows operators and functions that can be used in partitioning expressions.