Forcing the use of one index instead other.

From: "Edmundo Robles L(dot)" <erobles(at)sensacd(dot)com(dot)mx>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Forcing the use of one index instead other.
Date: 2009-06-02 16:45:47
Message-ID: 252EE06031407243B058CF7699226E3A0F893F@mail2.sensacd.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello there!

I have two index with a same field into them like this:

create index numberfail on Events (numberfail);
and
create index failtype on Events (numberfail,eventtype);

then i ran explain analyze and always took the numberfail index but i wish the failtype index;

this is the query:

SELECT * FROM events WHERE numberfail=194 AND eventtype='XXX';

What should i to do to force the use of failtypeindex????

I though maybe if i delete the index numberfail could works, but i don't know if the another program
will fail if the numberfail index does'nt exists.

well, thats all for the moment and i appreciate your time in reading this mail!!!
See you.
--
SENSA Control Digital.
Ing. Edmundo Robles Lopez.
Analista Programador.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-02 16:46:04 Re: timestamp no fractional seconds
Previous Message Brandon Metcalf 2009-06-02 16:45:34 Re: timestamp no fractional seconds