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.