Re: Help on query plan.

>
> Try like 50 or 100.  Also, does the EXPLAIN result change with the
> higher correlation figures?  I'd expect estimated cost of indexscan
> to drop with higher correlation.
>
> If you dig into the pghackers archives you will find some discussions
> about changing the equation used for adjusting indexscan based on
> correlation.  I suspect the real solution to your problem will be to
> alter the equation.  But I'm curious about whether we have reliable
> stats, first...
>


   Don't know what happened. Now it only shows me Index Scans, even if
it set the stats values back to 10 or less (tried 0 too). It's just
showing up Index Scans for that query.

   Now, I'm confused... =/

   what could have happened?

   william


--
Perl combines all of the worst aspects of BASIC, C and line noise.
                 -- Keith Packard