Search This Blog

Wednesday 6 February 2013

How To Find Index on Oracle Table?

select
substr(index_name,1,30) Index_nm,
substr(table_name,1,9) Table_nm,
substr(column_name,1,15) Column_nm,column_position
from all_ind_columns where table_name =upper('&table')
order by index_name,column_position

No comments:

Post a Comment