BUG
Indexes are not created on the archive class when enabling archiving
Description
When enabling archiving on an object class or feature classes in Oracle, user defined attribute indexes are not created on the new archive class.
Cause
When enabling archiving on an object class or feature class, user defined indexes are not created on the archive class, because of internal ArcSDE errors when creating the archive class.
Workaround
To workaround the issue, manually create the user defined index on the archive class in the underlying DBMS using the CREATE INDEX statement.For example, if the object class contained an index on the owner attribute, then the same index needs to be created manually on the archive class table's owner attribute.
Without the index on the archive class, queries using the non-indexed archive class table attribute may encounter poor performance.
Article ID:000009751
Software:
- Legacy Products
- ArcMap 9 x
Get help from ArcGIS experts
Download the Esri Support App
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback