IBM PureData System for Analytics, Version 7.1

$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