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.