Re: Index usage

On Tue, Aug 26, 2003 at 04:21:52PM +0200, Dennis Björklund wrote:
> On Tue, 26 Aug 2003, Pedro Alves wrote:
>
> >     It's the same even with statistics=1000.
>
> And just to be sure, you ran vacuum analyze on the tables by hand after
> the alter table?


    Yes

>
> >     Is there any way to enable_seqscan=off just for this query?
>
> Just set it before you run the query.

    Ok


--
Pedro Miguel G. Alves            pmalves@think.pt
THINK - Tecnologias de Informação    www.think.pt
Tel:   +351 21 413 46 00  Av. José Gomes Ferreira
Fax:   +351 21 413 46 09     nº 13 1495-139 ALGÉS