Hi Jake,
Thank you for the automation file again. But when I tried to run it, I got the following error message:
I am an administer of the geodatabase, but not the owner/creator.
I appreciate the automation file, but let me try to see/understand it step by step first. I still have some more questions please:
1. I’ve edited one layer in the geodatabase, but I still do the compression at the geodatabase level, not at the layer level, correct?
2. Since the compression is at the geodatabase level, I’d need to stop all services that came from this geodatabase, not only that particular one layer I’ve edited, correct? What happen if I forget to stop the services first before running compression?
3. Is compress by R-click on the geodatabase > Administration > Compress Database same as the GP Compress Tool?
4. Both results "SUCCESS", but the specific layer still draws slowly. I still should continue to perform other maintenance such as rebuild indexes and analyze, correct?
5. Should I just perform them all under R-click to the geodatabase > Administration > Geodatabase Maintenance?
6. The only time I absolutely need to stop services and unlock all layers is to recalculate Spatial Indexes for the specific layer. If not, the option would be grayed out.
7. What is the difference between Rebuild and Recalculate indexes?
Sorry for all the questions and thank you very much!