SQLServerCentral » Latest topics
execution plan is different on different servers.
Can someone shed light on why this might be? in production the query runs in 1 second, in dev it runs in 12 minutes. the difference in query cost comes from 'compute Scalar' regenerating rows in a view on DEV that apparently doesn't happen in prod.
No comments:
Post a Comment