On Thu, Oct 11, 2007 at 07:31:44AM -0500, Roberts, Jon wrote: > The cost is significantly lower but the total runtime is higher.
Um, so you want developers to change the thing so that it performs more slowly, but has a prettier estimate of how much work it's going to do? That seems like a poor optimisation to me. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match