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