Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4906👍, 0💬
Popular Posts:
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
How To Build WHERE Criteria with Web Form Search Fields? - MySQL FAQs - Managing Tables and Running ...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To...
How did you implement UML in your project ? PART II Implementation phase / Coding phase (Class diagr...