Solved! Go to Solution.
The documents you posted describe the operations. One rebuilds the indexes (which can
degrade in effectiveness over time), while the other updates the optimizer's metadata
(which can fall out of sync). Neither should be necessary without significant changes
to the data tables, but neither is likely to harm performance (except during operation).
I don't quite understand your thread Title, since Esri is working with the database in each
of these situations.
Forgive me for replying to an old post, but I have the same question. I don't think it was answered above. We are discussing options for maintenance with out DBA. They rebuild indexes on everything weekly. It that sufficient? The only task we use GP tools for is a nightly compress.
Anybody clear on which is better? 6 1/2 dozen?
Thanks for any input.