On Thu, 10 Mar 2005 10:24:46 +1000, David Brown <[EMAIL PROTECTED]> wrote: >What concerns me is that this all depends on the correlation factor, and >I suspect that the planner is not giving enough weight to this.
The planner does the right thing for correlations very close to 1 (and -1) and for correlations near zero. For correlations somewhere between 0 and 1 the cost is estimated by interpolation, but it tends too much towards the bad end, IMHO. Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])