> > Carlos wrote:
> > SELECT * FROM SSIRRA where
> > (YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00)
or
> > (YEAR = 2004 and CUSTOMER = 04 and CODE > 00) or
> > (YEAR = 2004 and CUSTOMER > 04) or
> > (YEAR > 2004)
> > [snip]
> >
> > ah, the positional query. Yo
On Tue, 6 Sep 2005, Merlin Moncure wrote:
> Carlos wrote:
> SELECT * FROM SSIRRA where
> (YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00) or
> (YEAR = 2004 and CUSTOMER = 04 and CODE > 00) or
> (YEAR = 2004 and CUSTOMER > 04) or
> (YEAR > 2004)
> [snip]
>
> ah,
Carlos wrote:
SELECT * FROM SSIRRA where
(YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00) or
(YEAR = 2004 and CUSTOMER = 04 and CODE > 00) or
(YEAR = 2004 and CUSTOMER > 04) or
(YEAR > 2004)
[snip]
ah, the positional query. You can always rewrite this query
On Sat, Sep 03, 2005 at 09:02:27PM +, Carlos Benkendorf wrote:
> Is there a way to improve the performance of the following query?
>
> SELECT * FROM SSIRRA where
> (YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00) or
> (YEAR = 2004 and CUSTOMER = 04 and CODE > 00
Hi,
Is there a way to improve the performance of the following query?
SELECT * FROM SSIRRA where (YEAR = 2004 and CUSTOMER = 04 and CODE = 00 and PART >= 00) or (YEAR = 2004 and CUSTOMER = 04 and CODE > 00) or (YEAR = 2004 and CUSTOMER > 04) or (YEAR > 2004)
Thanks in
