AnsweredAssumed Answered

Maintenance on one-way child replicas?

Question asked by aroust on Oct 21, 2015
Latest reply on Dec 24, 2015 by aroust

We have a one-way child replica of our master SDE database for our non-GIS staff to reference without being able to change the data. I run maintenance nightly on the parent database (compress, analyze, rebuild indexes), but I'm wondering if I need to do the same thing on the one-way child database? Since no one can edit on that child database, I'm wondering if the statistics and indexes just replicate over from the parent.

 

I haven't noticed any performance issues on the child replica, though I do have a nightly compress scheduled on it. I'm asking this as a "what's the best practice?" question.

 

Thanks in advance for feedback!

Outcomes