$v_hist_column_access_stats

The $v_hist_column_access_stats view lists the names of all columns that are captured during table access and provides some cumulative statistics.

Table 1. $v_hist_column_access_stats
Name Description
dbname The name of the database to which the session is connected
schemaname The schema name as specified in catalog.schema.table
tablename The table name of the table
columname The name of the column
refs The number of times that this column was referenced
num_selected
num_updated
num_where
num_grouped
num_having
num_ordered
num_altered
num_genstats
 The number of times this column was referenced in the following clauses
  • SELECT
  • UPDATE
  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY
  • ALTER
  • GENERATE STATISTICS