Request a Demo
Home   >   mailing lists

How to force PostgreSQL using an index - Mailing list pgsql-sql

From Daniel Caune
Subject How to force PostgreSQL using an index
Date
Msg-id 1E293D3FF63A3740B10AD5AAD88535D2019091DC@UBIMAIL1.ubisoft.org
Whole thread Raw
Responses Re: How to force PostgreSQL using an index
List pgsql-sql
Tree view

Hi,

 

Is there a way to force PostgreSQL using an index for a SELECT statement?  I just want to confirm that the index PostgreSQL decides to use is better than the index I supposed PostgreSQL would use (I already analyze the table).

 

Regards,

 

--

Daniel CAUNE

Ubisoft Online Technology

(514) 4090 2040 ext. 5418

 

pgsql-sql by date:

Previous
From: Maciej Piekielniak
Date:
Subject: Re: alter table
Next
From: "Owen Jacobson"
Date:
Subject: Re: How to force PostgreSQL using an index