Index Hint in Query builder or PHQL

Question

Index Hint in Query builder or PHQL

jeffreycahyono Jul '13

Created Jul '13	Last Reply Jul '13	Replies 1	Views 849	Votes 0

jeffreycahyono 27.7k

Jul '13

Hi, I use query builder and need to use Index hint to optimize my query. How can I add 'USE INDEX(key)' in Query Builder / or phql? if the feature hasn't been implemented in PHQL, Is there any workaround to use index hinting?

Phalcon · Answer 1 · 2013-07-05T07:26:53-07:00

Index hints aren't supported in PHQL, you can use a raw query if they're required: https://docs.phalcon.io/en/latest/reference/phql.html#using-raw-sql

jeffreycahyono · Answer 2 · 2013-07-05T08:17:08-07:00

jeffreycahyono
27.7k

Jul '13

Thanks @Phalcon. Sorry I missed reading that part.