GilaMonster (9/1/2015)
MaybeDepends 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.