hi Matt,

Assuming the execution plans are different, is there anyway to "force" the process to use one or the other?

The indexes are same as those in the live DB. Whatever indexes exist in the production, also exist in the replicated DB.

Like you said, there are 3 different copy of DBs.

1- the live DB in production;

2- DB with replication setup based on the live DB mentioned above (1); and

3- a...

Yes. I used the backup of the replicated db that i was testing.

Dev (2/7/2012)

---

It very much depends upon data volume & cube algorithm. If multidimensional processing is complex, it will certainly take time.

There could be other reasons as well for...