How using Query builder i can force DB (mysql) use a index.
like:
"select * from users join .... use index (name_index)"
I had similar problem. Query builder don't has something like that, so used for PHQL or plain SQL, i do not remember exactly.