Ofourse they should be using the same execution plan as it the same query which is being used. Ofcourse we don't get the execution plan in the Statspack Report. But, how do we know if it's the same execution plan being used or not as the Query is being fired from our Web Application. Is there any way by whcih we could improve the Query.

Ofcourse inspite of that I can always see atleast 850MB free memory in our Buffer Cache afetr the test. But, this Query probably is increasing the response times of all others also in our test.

regards,
Dileep T.V.R.