How to select all indexes used in table in Oracle
- Rumesh Aponso (RMAX)
- Nov 13, 2024
- 1 min read
SELECT index_name
FROM all_indexes
WHERE table_name = 'your_table'
AND owner = 'your_owner'top of page
Search
bottom of page
SELECT index_name
FROM all_indexes
WHERE table_name = 'your_table'
AND owner = 'your_owner'
Comments