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.