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';