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;
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;