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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How do we hint a query to use index in postgre
From: Manish Lad <manishlad7893@xxxxxxxxx>
Date: Thu, 18 Mar 2021 15:07:17 +0530
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAJycT5rri39Makb760phQD8myCbyoMeY4n1z7EZ9xn_s0zvmsg@mail.gmail.com>
References: <CAHWr2Cc0TAEQ-Af_x0zYPjZ5H5QerBU0d6cmzCTC6W5NLd2vew@mail.gmail.com> <CAHWr2CeC_Q+kOBY7O3HmX1qVRHch26yiDw6HeUZGGaBpANubVQ@mail.gmail.com> <CADPrz7-4hRu7kJ-4btqUGyAaifG3S6NZ_TyK-8uwUgP3BT2tjw@mail.gmail.com> <CAJycT5rri39Makb760phQD8myCbyoMeY4n1z7EZ9xn_s0zvmsg@mail.gmail.com>

Thank you for your response.

On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, <mendola@xxxxxxxxx> 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@xxxxxxxxx> wrote:

--
cpp-today.blogspot.com

Follow-Ups:
- Re: How do we hint a query to use index in postgre
  - From: Nikhil Shetty

References:
- Fwd: different execution time for the same query (and same DB status)
  - From: Francesco De Angelis
- How do we hint a query to use index in postgre
  - From: Manish Lad
- Re: How do we hint a query to use index in postgre
  - From: Gaetano Mendola

Prev by Date: Re: How do we hint a query to use index in postgre
Next by Date: SQL performance issue (postgresql chooses a bad plan when a better one is available)
Previous by thread: Re: How do we hint a query to use index in postgre
Next by thread: Re: How do we hint a query to use index in postgre
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux