Find column usage statistics - Oracle Database Script.
SET lines 150
SET pages 500 col TABLE_NAME
FOR a20 col COLUMN_NAME
FOR a20
SELECT a.object_name TABLE_NAME,
c.column_name,
equality_preds,
equijoin_preds,
range_preds,
like_preds
FROM dba_objects a,
col_usage$ b,
dba_tab_columns c
WHERE a.object_id=b.OBJ# and c.COLUMN_ID=b.INTCOL# and a.object_name=c.table_name and b.obj#=a.object_id and a.object_name='&table_name' and a.object_type='TABLE' and a.owner='&owner' order by 3 desc,4 desc, 5 desc;