Re: Or selection on index versus union

From: han(dot)holl(at)informationslogik(dot)nl
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Or selection on index versus union
Date: 2005-10-04 20:57:47
Message-ID: 200510042257.47117.han.holl@informationslogik.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 04 October 2005 22:26, kevin(dot)kempter(at)dataintellect(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-10-04 21:08:38 Re: Or selection on index versus union
Previous Message Douglas McNaught 2005-10-04 20:46:04 Re: Isolated transactions?