Oracle_91 (9/10/2012)

---

Hi All,

I have 2 sql sevr 2005 instances with same build no,same edition.

I restored the database from one insatnce to another instance. But when i execute the same query in the second instance , it poduces are different plan and my query performance is slow now on one instance.

Just wanted to understand how sql server or on what factors/basis sql servr produces are different plans if my stats are same ?

Thanks in Advance.