HOW TO
For Oracle databases, user defined indexes on existing feature classes are not automatically created on the corresponding Adds table after registering the feature class as versioned. Having such an index on the Adds table aids performance when retrieving records existing only in the Adds table.
SQL> select table_name, column_name, index_name from user_ind_columns
where table_name in (select table_name from sde.table_registry where owner=USER) order by 1;
SQL> select table_name, 'select dbms_metadata.get_ddl(''INDEX'','''||index_name||''') from dual;'
from user_ind_columns
where table_name in (select table_name from sde.table_registry where owner=USER) order by table_name, index_name;
SQL> select dbms_metadata.get_ddl('INDEX','I6450PARCEL_ID') from dual;
CREATE INDEX "GISADMIN"."I6450PARCELE_ID" ON "GISADMIN"."ZAB_PARCELS"("PARCEL_ID")
PCTREE 0 INITRANS 4 MAXTRANS 255 COMPUTE STATISTICS NO LOGGING
STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SDE";
SQL> select registration_id from sde.table_registry where owner=USER order by table_name;
CREATE INDEX "GISADMIN"."I6450_A228_PARCEL_ID" ON "GISADMIN"."A228" ("PARCEL_ID")
PCTFREE 0 INITRANS 4 MAXTRANS 255 COMPUTE STATISTICS NOLOGGING
STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SDE";
Get help from ArcGIS experts
Download the Esri Support App