MV_ROW_CHANGE_COUNTS

This view returns a row for each partition of each table with autostats (automatic statistics) hosted in the workspace, along with a change count.

These statistics are in-memory and show the number of changes (inserts, updates, and deletes) that have been applied to the table partition since it became online on the host.

Column name

Description

table_name

The name of the table in the database.

database_name

The name of the database associated with the activity.

partition

The table partition in the database.

changed

The count of changes (inserts, updates, and deletes) for a table partition.

token

The token associated with the table partition.

Last modified: August 29, 2022

Was this article helpful?