Re: Can relational alegbra perform bulk operations?
From: Walter Mitty <wamitty_at_verizon.net>
Date: Thu, 01 Oct 2009 10:28:29 GMT
Message-ID: <hv%wm.3891$tl3.1659_at_nwrddc01.gnilink.net>
Date: Thu, 01 Oct 2009 10:28:29 GMT
Message-ID: <hv%wm.3891$tl3.1659_at_nwrddc01.gnilink.net>
"Banana" <Banana_at_Republic.com> wrote in message
news:4AC42E40.4090008_at_Republic.com...
> any SQL products, commercial or not. Users have little incentive to adopt
> "good" behavior by letting optimizer doing their job. The blame lies
> squarely upon the feet of vendors (and to extent the standard committee as
> well)
I'm not following this. A good optimizer does one job, and lets the
database designer/developer focus on a different job.
If "good behavior" is simple yet sound design in both database definitions
and database transactions, then I would claim that a good optimizer does not
discourage good behavior as much as a bad optimizer does.