Monday, December 17, 2018

Find Out Table Columns That Are Indexed

I use the following query to find out columns that are indexed for a table.
select index_name, column_name from USER_IND_COLUMNS where table_name='MYTABLE'

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.