--- On Fri, 12/2/11, David Johnston <polobo@yahoo.com> wrote:
> From: David Johnston <polobo@yahoo.com>
> ---------------------------------------------------------
> My, possibly naïve, observation:
>
> So aside from the fact the estimates seem to be off the
> planner has still
> chosen the most effective plan? In that situation no
> matter how accurate
> you get the statistics you will not gain any performance
> because the planner
> will never choose a different plan.
>
Thanks.....
I'm not interested in optimizing this query.....it's fast and efficient. However, the planner thinks that it is going
toreturn a million rows when it is only going to return one thousand. When this query is used as an element of a
BIGGERquery, that causes me all sorts of planner issues....
That's the problem I am trying to solve...why the planner is 3 orders of magnitude off in row estimation.