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, 5164👍, 0💬
Popular Posts:
What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...
Can you explain Forms authentication in detail ? In old ASP if you where said to create a login page...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
How To Get the Uploaded File Information in the Receiving PHP Script? Once the Web server received t...
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...