Can i Force to postgrsql to use a certain index?

From: "Pau Marc Munoz Torres" <paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat>
To: pgsql-general(at)postgresql(dot)org
Subject: Can i Force to postgrsql to use a certain index?
Date: 2007-12-04 15:41:18
Message-ID: 19b5841a0712040741g129afcdftce2916c84ccf3309@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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-12-04 15:43:51 Re: difficulty extracting variable-sized field on triggered row
Previous Message Wim Chalmet 2007-12-04 15:27:44 Vacuum output redirect