When we ran gather Stats on the table, it generate table stats, index stats, and Column stats. Column Statistics are used in the optimizer’s selectivity calculations Let’s see how to find it How to check column statistics in Oracle Column stats can be found from dba_tab_columns or dba_tab_col_statistics SELECT column_name, num_distinct, density, num_nulls, avg_col_len, num_buckets, […]

The post How to check column statistics in Oracle appeared first on Techgoeasy.