Thread: How do we hint a query to use index in postgre
There is not such functionality, you can enable/disable special joins, or update statistics to drive the engine to use the most appropriate one. On Thu, Mar 18, 2021 at 10:14 AM Manish Lad <manishlad7893@gmail.com> wrote: -- cpp-today.blogspot.com
Thank you for your response.
On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, <mendola@gmail.com> wrote:
There is not such functionality, you can enable/disable special joins,
or update statistics to drive the engine to use the most appropriate
one.
On Thu, Mar 18, 2021 at 10:14 AM Manish Lad <manishlad7893@gmail.com> wrote:
--
cpp-today.blogspot.com
How about using pg_hint_plans?
Check it out if it helps your case.
Thanks and Regards,
Nikhil
On Thu, Mar 18, 2021, 15:07 Manish Lad <manishlad7893@gmail.com> wrote:
Thank you for your response.On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, <mendola@gmail.com> wrote:There is not such functionality, you can enable/disable special joins,
or update statistics to drive the engine to use the most appropriate
one.
On Thu, Mar 18, 2021 at 10:14 AM Manish Lad <manishlad7893@gmail.com> wrote:
--
cpp-today.blogspot.com