Difference Between Axxx_IX1 VS Sxxx_idx$

[yockee]

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.

[ChrisUnderwood]

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.

https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/spatial-indexes-and-stge...

[yockee]

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?

[MarceloMarques]

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.

[MarceloMarques · Accepted 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.

[yockee]

Many thanks for the explanation. Best regard