Horton

Re: query optimiser changes 6.5->7.0

Martijn van Oosterhout <kleptog@cupid.suninternet.com>

View thread View on postgr.es
From: Martijn van Oosterhout <kleptog@cupid.suninternet.com>
To: Alfred Perlstein <bright@wintelcom.net>
Cc: Wim Ceulemans <wim.ceulemans@nice.be>, Tom Lane <tgl@sss.pgh.pa.us>, Joseph Shraibman <jks@selectacast.net>, Simon Hardingham <simon@netxtra.net>, pgsql-general@postgresql.org
Date: 2000-06-02T14:48:57Z
Lists: pgsql-general 
Alfred Perlstein wrote:
> 
> * 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;

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