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 : [EMAIL PROTECTED]