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

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions