• keshab.basnet (4/17/2015)


    Dear Sir,

    We have 2 Database one is R/W(read/Write) and another is Read only database. And R/W database server replicates data in R only database server. Given issue is in Read only server as that query will be executed on Read only DB server. Okay drop previous my index and apply this index in production. One another Question Sir,

    If i make big index like this in Read only server, does it make replication slow?

    Thanks Sir In advance.

    There is a risk that it will make replication slow, but only by testing will you be able to tell whether the effect is large enough to matter.

    Tom