Re: query optimiser changes 6.5->7.0

From: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
To: Alfred Perlstein <bright(at)wintelcom(dot)net>
Cc: Wim Ceulemans <wim(dot)ceulemans(at)nice(dot)be>, 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 14:48:57
Message-ID: 3937C959.60CDC9EC@cupid.suninternet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alfred Perlstein wrote:
>
> * 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;

But doesn't this mean that if there are no appropriate
indicies defined on a table, queries will fail?
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-06-02 14:54:37 Re: client/server? odbc?
Previous Message Ed Loehr 2000-06-02 14:44:46 Re: Vacuum Question