Postgres Pro
Downloads
Home   >   mailing lists

Re: query optimiser changes 6.5->7.0 - Mailing list pgsql-general

From Alfred Perlstein
Subject Re: query optimiser changes 6.5->7.0
Date
Msg-id 20000602024714.L17973@fw.wintelcom.net
Whole thread Raw
In response to Re: query optimiser changes 6.5->7.0  (Wim Ceulemans <wim.ceulemans@nice.be>)
List pgsql-general
Tree view 
* Wim Ceulemans <wim.ceulemans@nice.be> [000602 02:33] wrote:
>
> Isn't there a way to tell the optimizer to use an index scan if one
> knows this is going to be the best.

set enable_seqscan=off;

-Alfred

pgsql-general by date:

Previous
From: Wim Ceulemans
Date:
Subject: Re: query optimiser changes 6.5->7.0
Next
From: Marcos Barreto de Castro
Date:
Subject: Operations widh CURSORS