please help me to understand.
What are the differences between the indexes Axxx_IX1 and Sxxx_idx$ ?
The Axxx_IX1 can be seen using this query : SELECT * FROM dba_indexes WHERE table_name = 'your_feature_class'; Here it says that Axxx_IX1 has Index_Type of "domain".
The Sxxx_IDX$ can be found using : SELECT * FROM sde.st_geometry_columns WHERE table_name = 'your_feature_class' --where xxx is the GEOM_ID colomn.
To see both of them : SELECT table_name,index_id,srid,grid,status,index_name
FROM sde.st_geometry_index WHERE table_name = 'your_feature_class' . From this article it says INDEX_NAME is Name of the st_spatial_index (domain index).
So I think they are different. But I do not understand the differences and when the A and S indexes are used.
Help please.
Solved! Go to Solution.
Question: What are the differences between the indexes Axxx_IX1and Sxxx_idx$?
Answer: Axxx_IX1 is a domain index while Sxxx_idx$ is a table.
See more details in the example below.
The Axxx Table & Index is for data that is Registered as Versioned, and holds information about objects that have been created or edited.
https://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/versioning-terms.htm
The Sxxx Table is a Spatial Index for data that uses the ST_Geometry spatial data type.
Thanks. Nice insight. But, how come I find the Axx table even though it's not registered as versioned ? Maybe it **was** registered as Versioned before and now it's not. Is it possible?
If the featuereclass/table in the geodatabase is registered as versioned (traditional) then the A & D tables are created, if you unregister as versioned (traditional) then the A & D tables are removed.
Question: What are the differences between the indexes Axxx_IX1and Sxxx_idx$?
Answer: Axxx_IX1 is a domain index while Sxxx_idx$ is a table.
See more details in the example below.
Many thanks for the explanation. Best regard