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: Gaetano Mendola <mendola@xxxxxxxxx>
Date: Thu, 18 Mar 2021 10:15:58 +0100
Cc: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CADPrz7-4hRu7kJ-4btqUGyAaifG3S6NZ_TyK-8uwUgP3BT2tjw@mail.gmail.com>
References: <CAHWr2Cc0TAEQ-Af_x0zYPjZ5H5QerBU0d6cmzCTC6W5NLd2vew@mail.gmail.com> <CAHWr2CeC_Q+kOBY7O3HmX1qVRHch26yiDw6HeUZGGaBpANubVQ@mail.gmail.com> <CADPrz7-4hRu7kJ-4btqUGyAaifG3S6NZ_TyK-8uwUgP3BT2tjw@mail.gmail.com>

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: Manish Lad

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

Prev by Date: How do we hint a query to use index in postgre
Next by Date: Re: How do we hint a query to use index in postgre
Previous by thread: 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