On Wed, 2005-01-19 at 21:00 -0800, [EMAIL PROTECTED] wrote: > Let's see if I have been paying enough attention to the SQL gurus. > The planner is making a different estimate of how many deprecated<>'' versus > how many broken <> ''. > I would try SET STATISTICS to a larger number on the ports table, and > re-analyze.
that should not help, as the estimate is accurate, according to the explain analyze. gnari ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])