Hi All, I have enabled slow query log. Generally this file will have sql's which take more than long-query time to execute and also sql's not using indexes. But i see sql's which does not come under the above condition. I have set the long-query time to 1 Sec .
The query takes less than 1 sec to execute and also uses indexes, but still its recored in slow query log. Any idea why this happens. Thanks for your help. regards anandkl