AnsweredAssumed Answered

Rebuild Indexes and Analyze arcpy vs. Oracle

Question asked by fallingdog on Nov 12, 2018
Latest reply on Jan 7, 2019 by fallingdog

We are trying to improve our geodatabase health. So we would like to: 

 

Rebuild Indexes—Help | ArcGIS for Desktop 

Update database statistics—Help | ArcGIS Desktop 

 

after a compress with arcpy.

 

According to our DBA oracle is already doing this as needed. Using estimate statistics and rebuild indexes. As I understand it oracle preforms an "analysis" per table to see if the estimate statistics and/or rebuild indexes is needed for any given table.

 

So, my questions are:

 

1) Is the rebuild indexes arcpy function the same as calling oracle's rebuild index?

2) Is the analyze arcpy function the same as calling oracle's estimate statistics?

3) Can we just go with what oracle has in place or is it recommended that we update indexes and statistics with arcpy after a compress?

Outcomes