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?