On Wed, May 01, 2002 at 11:54:37PM +0100, Nigel J. Andrews wrote:
>
> On Wed, 1 May 2002 postgres(at)vrane(dot)com wrote:
>
> Then run
> EXPLAIN ANALYZE SELECT * FROM TABLE <mytable> WHERE <booleanfield> = true;
>
> Then run
> UPDATE <mytable> SET <booleanfield> = false WHERE <booleanfield> = false;
>
> (several times)
>
> What you should see is a seqscan in both plans with the final number of rows
> the same but the second will have taken longer.
I haven't tried it yet but isn't creating an index here
the logical thing to do here. Whenever I have "where"
clause in my queries I always create an index.