Skip to main content

Search

Welcome to Tibero GTS!

Fix for Partition Statistics Collection Error When Using GATHER AUTO Option

Issue Number : 700337a

IssueWhen collecting statistics using the GATHER AUTO option, there are cases where the information for the table or index is not properly reflected under certain conditions.
Cause

When using the GATHER AUTO option, it is designed to update only stale data dictionary information.
If the table or index is partitioned, statistics for the higher-level object are updated by accumulating data at the partition level.

During this process, there was an issue where the accumulation of information for partitions that were not stale was not performed, resulting in statistics not being properly updated.

SolutionsIt has been modified so that data from partitions that are not stale is also accumulated, ensuring that table and index statistics are properly updated.