Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Updating Statistics on Partitioning Tables

As the search range is limited by partitioning pruning when a query is executed, the query plan does not include the partitioning information. Therefore, no statistics information update is required.

Note In versions lower than CUBRID 9.0, statistics information of the partitioning table has been updated by using the ANALYZE PARTITION syntax. From the CUBRID 9.0 version, no action is actually made even when this syntax is executed, however, it is not processed as an error for compatibility with the previous versions.