Hello. Is there a way to insert a USE INDEX statement in search query in basic search? Mysql uses wrong index for query. If I rewrite query with USE INDEX hint - it runs about 0.2 sec. But mysql always uses index that is useful for sorting, not for getting data.
Analyze and optimize are executed once a week - that doesn't help.
Thanks in advance.