can I find out which columns are being used or not in a table?

[wjramsey]

Dorthy

You could do something like the following

select column_name
from dba_tab_columns
where table_name = <table of interest>
and num_distinct = 0

The tables will have had to be analyzed first in order for the statistics to be there though.

Joe