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
Finding Unique Index Keys - Oracle
Posted by
Michael Nitschke
on Friday, 29 August 2008
Labels:
oracle sql index key keys table
0 comments:
Post a Comment