question

erlokeshsharma08 avatar image
erlokeshsharma08 asked

SQL QUERY NIGHTMARE!

Hi Guys Greetings for the day, Can you please read my blog and answer. It is regarding a query running very slow in PROD against the DEV. Here is the url:- http://itchallengesdaily.blogspot.in/2016/09/sql-query-nightmare.html Thanks Lokesh
performance-tuningquery-tuning
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
did dev and prod both generate the same query plan? when were statistics last updated in prod?
1 Like 1 ·
erlokeshsharma08 avatar image erlokeshsharma08 commented ·
Hi Ken yes the query plans were identical and in prod the stats are updated on daily basis. Whereas in DEV they are updated on weekly basis. Thanks
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.