Our customer had encountered some performance issue when running a particular procedure after they refresh the database instance. They duplicate the instance using the disk to disk copy via fiber on different Compact Tru64 machine. It should be exactly the same for both of the database. (all database objects and data was identical)
It took about 30 sec to run the procedure in the production instance. However, when they run the same procedure in the new instance we face the performance issue. It take >30 minutes to finish and sometime it would continue running >1hrs and never finish.
However, we can get rid of these if we created a new view on the particular table inside the procedure. And we need to explain to them why this happen.
1. What could be the possible problem in this case? Please explain your answer.
Thanks in advance.