-
Oracle query optimization needed
Hi,
Are there any geniuses that can see ways to optimize the following query?
SELECT
SYS.ALL_IND_COLUMNS.INDEX_NAME AS INDEXNAME,
SYS.ALL_IND_COLUMNS.COLUMN_NAME AS FIELDNAME,
SYS.ALL_IND_EXPRESSIONS.COLUMN_EXPRESSION as COLUMN_EXPRESSION
FROM
SYS.ALL_IND_COLUMNS JOIN SYS.ALL_IND_EXPRESSIONS ON SYS.ALL_IND_COLUMNS.INDEX_NAME = ALL_IND_EXPRESSIONS.INDEX_NAME
AND SYS.ALL_IND_COLUMNS.INDEX_OWNER = ALL_IND_EXPRESSIONS.INDEX_OWNER
AND SYS.ALL_IND_COLUMNS.COLUMN_POSITION = ALL_IND_EXPRESSIONS.COLUMN_POSITION
ORDER BY
SYS.ALL_IND_COLUMNS.INDEX_NAME,
SYS.ALL_IND_COLUMNS.COLUMN_POSITION
It runs very slowly and needs to be optimized for the application we are building.
Any feedback is much appreciated.
Thanks,
Jacob
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|