Re: Seq scan vs index scan

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: arun chirappurath <arunsnmimt(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Seq scan vs index scan
Date: 2024-03-23 04:02:49
Message-ID: CAKFQuwZba6j1-_d8cdFiLgq9uoZ1WA1EdmGUR0B_R-K_NLNJKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 22, 2024 at 8:55 PM arun chirappurath <arunsnmimt(at)gmail(dot)com>
wrote:

>
> I am trying to force query to use indexes using query hints.
>
> Set enable indexscan to ON,
> Same for bitmap and index only scan
>

Everything is on by default in the planner. You need to think in terms of
what you don't want to happen and disabled those things.

David J.

>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-03-23 04:13:16 Re: Seq scan vs index scan
Previous Message Christophe Pettus 2024-03-23 04:02:18 Re: Seq scan vs index scan