I have a problem with my oracle query.It is maximum tuned by me in the back end level.But when i am trying to call this from
my javaservlet ,it is taking the same time how much it took before tuning.can anybody help me in this?very urgent please...
Interesting User name for a professional developer but I feel you might want to change it according to the Javaranch rules.
I can guess how important/urgent resolving this problem could be for you. But have a look at the question you have posted.
There is absolutely no data available other than that you have tried to fine-tune your query from the Database end. Seems the query is not giving better performance. Were you to add more information in your post as to what you are trying to achieve, how you are accessing the Data/Db layer from your application, details of the query etc. someone could suggest better approaches.