Checkschema looks for obsolete indexes on ADDs and DELETEs tables

Description

Checkschema may report that some indexes are missing, producing this output for one of its tests.

Code:

. . .

!!!!!!!!!!!!
TEST FAILED >>>> ArcSDE for Oracle Compressed Binary format complete
!!!!!!!!!!!!
-- Test Category: Index Analysis
-- Test Description: Check whether indexes on ArcSDE for Oracle 
compressed binary layer have correct indexes. Also checks indexes 
on ADDs and DELETE tables.
-- Result Details: 
Error: Missing index An_STATE_IX2

Error: Missing index Dn_IDX2 
(The previous errors were for layer OWNER.TABLE.COLUMN (layer ID#))

. . .

Cause

This checkschema test checks for the existence of indexes and other components of an ArcSDE compressed binary feature class. Each versioned feature class, or layer, has a corresponding ADDs table and DELETEs table. Because some indexes are no longer created at ArcSDE 9.0 final, this test gived a false failure.

This is a known problem.

At ArcSDE 9.0 final, the these indexes were removed:

- ADDs table: Annn_STATE_IX2
- DELETEs table: Dnnn_IDX2

Workaround