Skip to main content

MV_COLLECTED_ROW_CHANGE_COUNTS

This view displays the best-effort counter for the number of changes that have been observed for the table partitions over time, and persisted to disk.

Column name

Description

table_name

The name of the table.

database_name

The name of the database containing the table.

partition

The ID of the partition.

total_changes

The total cumulative number of rows changed for this table on this partition.

last_analyzed_total_changes

The last recorded change count, when the statistics collection was triggered based on the metadata.