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/