Improving performance of a query - Mailing list 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