Re: Or selection on index versus union - Mailing list pgsql-general

From han.holl@informationslogik.nl
Subject Re: Or selection on index versus union
Date
Msg-id 200510042257.47117.han.holl@informationslogik.nl
Whole thread Raw
In response to Re: Or selection on index versus union  (kevin.kempter@dataintellect.com)
List pgsql-general
On Tuesday 04 October 2005 22:26, kevin.kempter@dataintellect.com wrote:
> Just a guess but have you tried using an in clause?
>
> select something from table where fase in  ('1' , '2');
>
Not surprisingly, this also does a sequential scan on the table. (It would be
_very_ diffcult to see that this is a union, I guess).

Thanks,

Han

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Or selection on index versus union
Next
From: Matthew Terenzio
Date:
Subject: Re: License question