AnsweredAssumed Answered

USE INDEX in basic search query

Question asked by Ilya Antipov on Aug 24, 2017
Latest reply on Aug 24, 2017 by Ilya Antipov

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.