Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To See the Table Columns Used in an Index
How To See the Table Columns Used in an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes
✍: FYIcenter.com
You can a list of indexes in your schema from the USER_INDEXES view, but it will not give you the columns used in each index in the USER_INDEXES view. If you want to see the columns used in an index, you can use the USER_IND_COLUMNS view. Here is an example script for you:
SELECT index_name, table_name, column_name FROM USER_IND_COLUMNS WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME COLUMN_NAME -------------------- ---------------- ---------------- EMP_EMAIL_UK EMPLOYEES EMAIL EMP_EMP_ID_PK EMPLOYEES EMPLOYEE_ID EMP_DEPARTMENT_IX EMPLOYEES DEPARTMENT_ID EMP_JOB_IX EMPLOYEES JOB_ID EMP_MANAGER_IX EMPLOYEES MANAGER_ID EMP_NAME_IX EMPLOYEES LAST_NAME EMP_NAME_IX EMPLOYEES FIRST_NAME
2007-04-27, 5299👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - What is COM ? Microsoft’s COM is a technology for component software deve...
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...
What is XSLT? XSLT is a rule based language used to transform XML documents in to other file formats...
How Are Vertical Margins between Two Block Elements Collapsed? - CSS Tutorials - Understanding Multi...
How To Select an Oracle System ID (SID)? - Oracle DBA FAQ - Creating New Database Instance Manually ...