[GENERAL] Can i Force to postgrsql to use a certain index?

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 C

Re: [GENERAL] Can i Force to postgrsql to use a certain index?

Pau Marc Munoz Torres wrote: 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? No. PostgreSQL will not allow

[GENERAL] Can i Force to postgrsql to use a certain index?

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