Updating Indexes

In many cases the structure of the columns in the table remains intact, but indexes are changed, added or removed.  

 

Index metadata can be refreshed on any table by using the Refresh index button in the data dictionary manager, without performing a complete re-import of the object metadata.  

 

Index information for the complete data dictionary can be refreshed by using the Update Statistics option in the data dictionary manager.  This is equivalent to selecting Refresh index on every table in the CDD.

 

The Refresh Index and Update Statistics functions are only available via the CDD Manager.