question

abbasmehmood avatar image
abbasmehmood asked

Same Query, Same Server , Same Schema BUT different Execution Plan and completeion time

Hello, i have this strange problem.i am running a query in DEV and its completing in 87 Sec, tried same query in Prod and ran in 1 sec. Off course Prod server is more powerful ,so i restore backup from Prod and restored on same DEV server and ran the query and it ran in 1 sec on Prod DB copy in DEV server.i compared schema, index, updated stats but no luck. will appreciate any help. Thanks [link text][1] [1]: /storage/temp/4194-planwithshortertime.xml
execution-plan
10 |1200

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

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.