laravel-postgresql-enhanced icon indicating copy to clipboard operation
laravel-postgresql-enhanced copied to clipboard

Ability to add query hinting to make use of pg_hint_plan

Open aijorgenson opened this issue 9 months ago • 7 comments

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

aijorgenson avatar May 10 '24 14:05 aijorgenson