39.7. Retrieving Analytical Table Column Statistics #

Analytical table column statistics are contained in pga_table_column_stats and pga_column metadata tables.

On the server with the metadata catalog, execute the following command:

  SELECT c1.column_name, s1.contains_null, s1.min_value, s1.max_value
  FROM axe_catalog.pga_column c1, axe_catalog.pga_table_column_stats s1, axe_catalog.pga_table t1
  WHERE c1.table_id = t1.table_id AND t1.table_name = 'table_name' AND s1.column_id = c1.column_id;

Where table_name is the name of the analytical table from the pga_table metadata table.