Mysql Slow query execution

Question

Hi All,

I have one procedure which retrieves all the records from one table which has more than 20000 records and two columns. the column i m trying to retrieve has the index on it.

But still it takes more than 1-2 minutes to execute.

Can anyone provide any input on this.

Answer 1

Slow_Query_log was helpful to sort this problem. I was using subqueries in the main query that was the problem.

Thanks for all your support.