topic Re: Rebuilding Index using arcpy taking long time in ArcSDE (SQL Server) in Geodatabase Questions

Rebuilding Index using arcpy taking long time in ArcSDE (SQL Server)

VikramS — Sun, 12 Jul 2015 14:43:45 GMT

Hello All,

I am having a process which truncates and loads 1 million nightly. The feature class has an index applied . After my load completes the process rebuild index and analyzes the feature class. Rebuilding Index and Analyze dataset alone takes 1.5 hr .

I have compressed the database. Tried deleting and recreating the index. No change

I am sure something is not write. Can anyone point me how to identify the issue and solve it

Thanks,

Re: Rebuilding Index using arcpy taking long time in ArcSDE (SQL Server)

ChrisSmith7 — Sun, 12 Jul 2015 22:20:50 GMT

Vikram,

There are some helpful recommendations in this thread:

http://dba.stackexchange.com/questions/49719/improve-speed-of-index-rebuild-on-sql-server

Re: Rebuilding Index using arcpy taking long time in ArcSDE (SQL Server)

VikramS — Mon, 13 Jul 2015 15:43:56 GMT

Okay some more notes

I tried rebuilding the index directly in SQL Server it ran in seconds. So I am not sure why it is taking so much time to rebuild index and analyze dataset.

What could impact the performance of rebuilding index and analyze dataset when run through arcpy.

Re: Rebuilding Index using arcpy taking long time in ArcSDE (SQL Server)

JakeSkinner — Fri, 17 Jul 2015 13:31:45 GMT

Hi Vikram,

Is your feature class registered as versioned? If it is, the Rebuild Index tool will rebuild the index for the delta (A & D) tables as well as the base table. If the compress is not successfully clearing the delta tables, this could be causing the long time you are experiencing when building the indexes.