Horton

Re: query optimiser changes 6.5->7.0

Alfred Perlstein <bright@wintelcom.net>

View thread View on postgr.es
From: Alfred Perlstein <bright@wintelcom.net>
To: Wim Ceulemans <wim.ceulemans@nice.be>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Joseph Shraibman <jks@selectacast.net>, Simon Hardingham <simon@netxtra.net>, pgsql-general@postgresql.org
Date: 2000-06-02T09:47:14Z
Lists: pgsql-general 
* 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