Postgres Pro
Downloads
Home   >   mailing lists

Can i Force to postgrsql to use a certain index? - Mailing list pgsql-general

From Pau Marc Munoz Torres
Subject Can i Force to postgrsql to use a certain index?
Date
Msg-id 19b5841a0712040834x20caa857u9af825afe8f0d330@mail.gmail.com
Whole thread Raw
Responses Re: Can i Force to postgrsql to use a certain index?
List pgsql-general
Tree view
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.munoz@bioinf.uab.cat

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: difficulty extracting variable-sized field on triggered row
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Can i Force to postgrsql to use a certain index?