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 you to do that. Not to mention, a SELECT *
without a where clause will always scan the whole table so an Index
would be useless.
Joshua D. Drake
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@xxxxxxxxxxxxxx <mailto:paumarc.munoz@xxxxxxxxxxxxxx>
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
