Differences in Query execution plan between 2 servers

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  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.

• iashurova

  Ten Centuries

  Points: 1032

  More actions

  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!!!!!