Saturday, December 17, 2016

find Indexes created on table


Query to find the list of all indexes created on a table.

SELECT index_name, column_name, column_position
FROM dba_ind_columns
WHERE table_name like upper('&table_name')
ORDER BY index_name, column_position;

No comments:

Post a Comment