Select to view content in your preferred language

Validate sql geodatabase feature class spatial index - greyed out?

243
1
Jump to solution
06-04-2024 02:12 PM
Labels (1)
AndreaB_
Occasional Contributor II

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 | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ 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 | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos