dba_index and dba_ind_columns
How will you find if there is an index created on a table.
column table_owner format a15
column table_name format a20
column index_name format a20
column column_name format a20
Select index_owner, table_name, index_name, column_name FROM dba_ind_columns where INDEX_OWNER='schema' AND table_name='tablename';
Comments
Post a Comment
Welcome to the Oracle DBA Blog.
Stay Hungry Stay Foolish