On Jul 13, 2009, at 1:06 PM, Simon Riggs wrote:
> Not just because of this but I wonder if we might benefit from an
> optimizer setting specifically aimed at the foolishnesses of
> automatically generated SQL.
+1. And it's not just ORMs that do stupid things, I've seen crap like
this come out of users too (not this exact case, but similar).
Perhaps what we really want is an "optimization level" GUC so that
users can tell the backend how much overhead they want the optimizer
to spend on trying to work around stupidity... :)
--
Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828