Improving performance of a query

From: Carlos Benkendorf <carlosbenkendorf(at)yahoo(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: Improving performance of a query
Date: 2005-09-03 21:02:27
Message-ID: 20050903210227.75394.qmail@web35508.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Is there a way to improve the performance of the following query?

SELECT * FROM SSIRRA where
(YEAR = 2004 and CUSTOMER = 0000000004 and CODE = 00 and PART >= 00) or
(YEAR = 2004 and CUSTOMER = 0000000004 and CODE > 00) or
(YEAR = 2004 and CUSTOMER > 0000000004) or
(YEAR > 2004)

Thanks in advance!

Benkendorf

__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2005-09-03 22:11:00 Re: Improving performance of a query
Previous Message Mark Kirkwood 2005-09-03 01:22:01 Re: Massive performance issues