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?

srividhya_85
Profile Answers by srividhya_85 Questions by srividhya_85
Apr 26th, 2018
2
6586

Questions by srividhya_85 answers by srividhya_85

Database Tuning

Answer

Showing Answers 1 - 2 of 2 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.