sql query optimization - TechRepublic
Question
June 14, 2007 at 02:37 AM
neelu_munna

sql query optimization

by neelu_munna . Updated 19 years, 1 month ago

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

This discussion is locked

All Comments