Can i Force to postgrsql to use a certain index?

From: "Pau Marc Munoz Torres" <paumarc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can i Force to postgrsql to use a certain index?
Date: 2007-12-04 16:34:08
Message-ID: 19b5841a0712040834x20caa857u9af825afe8f0d330@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi every body

it is possible to force to postgresql to use a certain index? I know that
in mysql exits Force index (index_name) option for select queries
SELECT * FROM precalc FORCE INDEX (hladrb50101) ;

any of you have used this?

thanks

pau

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-12-04 16:37:21 Re: Can i Force to postgrsql to use a certain index?
Previous Message Tom Lane 2007-12-04 16:29:06 Re: difficulty extracting variable-sized field on triggered row