Tuesday 10 May 2016

Query to Check to see what Indexes are on a Table

The relevant query is as follows:

SELECT index_name
FROM    all_indexes
WHERE table_name = ‘<TABLE_NAME>’;

No comments:

Post a Comment