We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.

Force Builder Query use index

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.