• 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.

    Are there any differences in how the instances are configured? Are the instances on the same server or different servers? If different servers, how are these servers configured?