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.