Show the output of a Query Plan to User

There is a query which takes more time in production, the user has reported the issue, and we have fine tuned the same and it is working fine now in testing environment, we need to explain the user the root cause and also we need to show the user the query is running fine in production. How to show the query performance upgrade to the user in production environment?
For the same issue, we have fine tuned and it is working fine for 10 million records, now the data has reached maximum of 50 million records and the same query , which we have tuned is getting slow. What can be the issue now?

Questions by srividhya_85   answers by srividhya_85

Showing Answers 1 - 3 of 3 Answers

Ranvir thakor

  • May 23rd, 2019
 

it could be the case where that query use the table which may get affected by high volume of DML operations and table statistics are not updated one so when query is getting executed optimizer referring the old plan with old values. again there could be the issue like some maintenance operation is carried out during peak hour like backing up custom of data other than its schedule timing.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions