How to force PostgreSQL using an index

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How to force PostgreSQL using an index
Date: 2006-02-15 21:58:54
Message-ID: 1E293D3FF63A3740B10AD5AAD88535D2019091DC@UBIMAIL1.ubisoft.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2006-02-15 22:06:55 Re: How to force PostgreSQL using an index
Previous Message Maciej Piekielniak 2006-02-15 20:29:29 Re: alter table