How do I find out which columns are indexed in the table?
Printable View
How do I find out which columns are indexed in the table?
SQL> desc DBA_IND_COLUMNS
Name Null? Type
------------------------------- -------- ----
INDEX_OWNER NOT NULL VARCHAR2(30)
INDEX_NAME NOT NULL VARCHAR2(30)
TABLE_OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
COLUMN_POSITION NOT NULL NUMBER
COLUMN_LENGTH NOT NULL NUMBER
DESCEND VARCHAR2(4)
Here is a Query
Select Index_name, Table_Name, Column_Name
From Dba_Ind_Columns
where Upper(Table_name) = '&Table_Name';
It Will Give you the required results for particuler Table, If want all, Omit Where.
Thanks