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 log. Now i found that the same queries having force index clause are againg not using index and surprisingly its starting using index without any force index clause.
Please suggest how it happened and should i continue with the force index command in that query or remove the force index clause from those queries ? Thanks & Regards Jeetendra Ranjan