Select to view content in your preferred language

Validate sql geodatabase feature class spatial index - greyed out?

472
1
Jump to solution
06-04-2024 02:12 PM
Labels (1)
AndreaB_
Frequent Contributor

Hello all,

I am trying to follow this: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/modifying-a-spatial-index.h... where it says to 'Validate a spatial index in SQL Server' but when I look at my feature class properties the "Validate" button is greyed out?

AndreaB__0-1717535498298.png

Related: 

I'm running this Rebuild Indexes Geoprocessing tool in Pro https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/rebuild-indexes.htm so it says it rebuilds attribute and spatial indexes. So maybe I don't need to separately Validate the feature class spatial index and/or run the Recalculate Feature Class Extent (Data Management) GP tool?

Thanks!

0 Kudos
1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

If the Validate is grayed out, just run the recalculate and then recreate the spatial index, you can also drop the spatial index and create the spatial index again. Regards.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

0 Kudos
1 Reply
MarceloMarques
Esri Regular Contributor

If the Validate is grayed out, just run the recalculate and then recreate the spatial index, you can also drop the spatial index and create the spatial index again. Regards.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
0 Kudos