SELECT   ‘, ‘ || dtc.column_name
, dtc.num_distinct
, dtc.avg_col_len
FROM     dba_tab_cols dtc
WHERE    dtc.owner = ‘DWFACTS’
AND      dtc.table_name = ‘STATELINES_FACT’
ORDER BY dtc.num_distinct
, dtc.avg_col_len DESC;