Force index command in query

------=_NextPart_000_0087_01CA938E.38500D90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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
------=_NextPart_000_0087_01CA938E.38500D90--