Finding Unique Index Keys - Oracle

Will give you a list of indexes used by the table:
select * from all_indexes where table_name = 'T931_ACCOUNT_SWITCHING';

Will return fields (or keys) used by the index:
select * from all_ind_columns where table_name = 'T931_ACCOUNT_SWITCHING'
and index_name = 'T931_ACCOUNT_SWITCHINGP1'
order by 1,2,3,4,6

0 comments: