laravel-postgresql-enhanced
laravel-postgresql-enhanced copied to clipboard
Ability to add query hinting to make use of pg_hint_plan
It would be nice if there was a way to prefix queries with hints for extensions. For example, an officially recognized extension ( https://www.postgresql.org/about/news/pg_hint_plan-v160-released-2712/ ) pg_hint_plan which allows you to modify which index is utilized for a query.
https://github.com/ossc-db/pg_hint_plan
Syntax looks like so:
/*+ Something(my_table index_name) Something(my_other_table other_index_name) */
select * from my_table mt join my_other_table mot on mot.my_table_id = mt.id