Skip to main content
Released

Update Spatial Index on the Esri Geodatabase Writers

Related products:Transformers
  • June 5, 2017
  • 9 replies
  • 175 views
frro
Contributor
Forum|alt.badge.img+17

I'd love to see a parameter on the writer feature types of the Esri Geodatabase Writers where you have an option to create or update the Spatial Indexes for the Esri Geodatabase feature types.

It would be a great feature to update/rebuild spatial index on the feature types after they have finished loading. This would make your data ready to go after a big data loading job has completed. Then you wouldn't have to rely on some custom Python hack to update you spatial indexes.

The writers I see can benefit from this feature are:

  • Esri Geodatabase (GEODATABASE_SDE)
  • Esri Legacy ArcSDE (SDE30)
  • Esri Geodatabase (File Geodb API)
  • Esri Geodatabase (File Geodb ArcObjects)
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

9 replies

joehansson
Participant
Forum|alt.badge.img
  • joehanssonParticipant
  • Participant
  • June 7, 2017

Hi!

This would greatly improve the usability and convenience of using the ESRI geodatabase writer.

Regards,

Joe Hansson

 

m_tengbrand
Participant
Forum|alt.badge.img
  • m_tengbrandParticipant
  • Participant
  • July 3, 2017

Agrees that it would simplify a lot!

L

Please add the option to update/rebuild spatial index in a ESRI GDB!

runneals
Enthusiast
Forum|alt.badge.img+29
  • runnealsEnthusiast
  • Enthusiast
  • July 18, 2017

The current work around is using a python script with arcpy management tools. It also looks like you could potentially use a sql statement to rebuild them.

F

I am using pythonCaller with both AddSpatialIndex_management and RebuildIndexes_management to create spatial index extent for feature classes under a MS Sql Server spatial database but it seems it is not working as expected, nothing happens.

Anyone had this issue?

Any workaround?

chriswilson
Enthusiast
Forum|alt.badge.img+22
  • chriswilsonEnthusiast
  • Enthusiast
  • February 18, 2020

Bump for this, it would be tidy if it's practical to achieve this with the writer rather than looking at python scripts. Perhaps it could remove the index at the start of writing, write features then re-add the index and maybe even auto-calculate based on feature sizes?

jhawks
Contributor
Forum|alt.badge.img+7
  • jhawksContributor
  • Contributor
  • October 12, 2022

Were very interested in this

bgeorges
Contributor
Forum|alt.badge.img+6
  • bgeorgesContributor
  • Contributor
  • February 24, 2023

Totally. When you truncate / append the whole table every day to keep the data up to date, you have to rebuild the indexes somehow.

aquee
Contributor
Forum|alt.badge.img+3
  • aqueeContributor
  • Contributor
  • March 16, 2023

Page quoted has been removed from Esri support and does not appear to be maintained any more. It was Article ID: 000006051 "FAQ: How can ArcSDE performance be improved?" for oracle 8/9/10 or SQL Server 200/2005, and is available from archive.org circa 2017/2018.

 

I won't repost here but it involved running SQL as the SYS or SA/dbo user on either dba_indexes or using dbcc dbreindex. I believe this is no longer an Esri approved method for administering indexes any more (Our DBA would not allow us to do this, so it is moot.) and has moved to Python/GPT.

 

example: Rebuild system table indexes (ArcGIS Pro latest)

 

Failing an in-Workspace feature, we're using arcpy either separately in batch (custom task/application) or as part of the workspace scripting shutdown python parameter: Question: Update spatial index

 

Community Stats

32,756
Posts
124,210
Replies
41,269
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.