Post reply

Differences in Query execution plan between 2 servers

  • July 31, 2012 at 10:02 am

    #1519823

    iashurova (7/31/2012)

    Just tried it with and without (nolock) option - doesn't make any difference.

    Didn't expect NOLOCK would change the plan, it's just inadvisable for other reasons.

    What about using ANSI joins? Both sets of plans seem to have huge cross joins in them, so I don't think either is optimal.

  • July 31, 2012 at 11:46 am

    #1519875

    I tried it with nolock and without, but it didn't have any impact on a bad query plan 🙁 the only improvement I saw when i put the table in the correct order and force SQL Server to use it.

    thank you all of you. The autostats were turned off on tempdb. We turned it on and it workis!!!!!

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply