Hi All, I want to improve the Performance of the Application.We have a 3 Environments. in One Environment its retrieving records around 5 sec where as in the another Environment its retrieving records in around 25 sec.Off course more data in another Environment.And also we have a indexes.
can any one suggest how can i improve the performance.
Mastan, The first step is to see where the time is going. For example, how much is query runtime vs network traffic? Are there any table scans when you run Oracle explain?
