Analyze the schema and then issue:
select index_name, distinct_keys from dba_indexes where owner='name';
The lower the # of distinct keys, lower is the selectivity of the index.