• GilaMonster (9/1/2015)


    Maybe

    Depends if the index is useful to the query and the query capable of using the index.

    Not knowing how you're replicating the data, it's a little hard to suggest alternatives or improvements.

    Thanks. I will come back here once the assignment is officially on me, by then I will know the current process and maybe apply certain changes on it and hopefully helpful to the query performance.