Re: How do we hint a query to use index in postgre

2021-03-26 Thread Nikhil Shetty
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 wrote: > Thank you for your response. > > > > > On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, wrote: > >> There is not such functionality, you can enable/disable

Re: How do we hint a query to use index in postgre

2021-03-18 Thread Manish Lad
Thank you for your response. On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, 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 > wrote: >

Re: How do we hint a query to use index in postgre

2021-03-18 Thread Gaetano Mendola
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 wrote: -- cpp-today.blogspot.com