Question Locked

sql query optimization

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
my query is taking some 2029 msec to execute and my client requirment is it must be atleast reduced to 30% , i had created the indexes on the coloumns in the where clauses, and passed parameters to the coloumns and tried but still the performance didnt improved can u please suggest me how can i proced to improve the performance and to reduce the query execution time? and the application is a java application running on a linux server

3 replies

by shellbot

it could be your query..
post the query..hard to know whats happening if can't see it..

by tony hopkinson

Is that 2+ seconds in the application of just for the query itself?

How long does it take running direct on the server ?

Without the query we can give you very little help.

This discussion is closed to new replies.