On 09/12/2009, at 5:10 PM, Jeetendra Ranjan wrote:
Hi,
After analysing slow query log i found that some queries are not
using index and so i used the force index command in query and test
it and now it starts using index properly.Accordingly i implemented
the same query with force index
Hi,
After analysing slow query log i found that some queries are not using index
and so i used the force index command in query and test it and now it starts
using index properly.Accordingly i implemented the same query with force index
in my application code and regeneratet the slow query