Tables with Composite Indexes [message #378757] |
Thu, 01 January 2009 04:53  |
Serious Sam
Messages: 21 Registered: September 2007
|
Junior Member |
|
|
Is it possible to find the table names having composite indexes created on them? If so, Can any one please let me know which data dictinary stores the details of composite indexes? I have seen in user_indexes, user_tables,user_segments etc.,. But, I couldnt find any.
Sam
|
|
|
|
Re: Tables with Composite Indexes [message #378759 is a reply to message #378757] |
Thu, 01 January 2009 05:24   |
Serious Sam
Messages: 21 Registered: September 2007
|
Junior Member |
|
|
Michel,
Thanks for the reply. But, i need to find only the table names which have composite indexes created on it.This will just display the tables name and indexes created on them. But, how can i find whether it is a composite index?
Sam
|
|
|
|
|
|
Re: Tables with Composite Indexes [message #378767 is a reply to message #378766] |
Thu, 01 January 2009 07:07   |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
Sorry about that. I had no idea what was going on when you asked a question to which both you and the OP clearly knew the answer. It just seemed weird and I wanted it to get normal again. Quickly.
If you are trying to help people develop research or descriptive skills, then you should be up-front and explain that you are offering guidance and not a solution.
Then I will know what you up to and leave you alone to get on with it.
Nuance is a very difficult thing to get across in 10pt Arial.
|
|
|
|
|
|