Start a new topic

indexes of table are only shown when the index in table_owner's schema

[This topic is migrated from our old forums. The original author name has been removed]

Hi roger, while playing with the profiles I noticed that the sql to retrieve the indexes for a table does not take into account the possibility that an index does not have to be in the same schema. It is common praktice to have them in the same schema but it is often a little different. Ronald.