Re: query optimiser changes 6.5->7.0

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Wim Ceulemans <wim(dot)ceulemans(at)nice(dot)be>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joseph Shraibman <jks(at)selectacast(dot)net>, Simon Hardingham <simon(at)netxtra(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: query optimiser changes 6.5->7.0
Date: 2000-06-02 09:47:14
Message-ID: 20000602024714.L17973@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Wim Ceulemans <wim(dot)ceulemans(at)nice(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcos Barreto de Castro 2000-06-02 11:29:30 Operations widh CURSORS
Previous Message Wim Ceulemans 2000-06-02 09:06:04 Re: query optimiser changes 6.5->7.0