Обсуждение: How do we hint a query to use index in postgre

Поиск
Список
Период
Сортировка

How do we hint a query to use index in postgre

От
Manish Lad
Дата:

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

От
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 <manishlad7893@gmail.com> wrote:



-- 
cpp-today.blogspot.com

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

От
Manish Lad
Дата:
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

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

От
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 <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