Re:Easy Steps to a Complete Understanding of SQL
by chris_wot on Tuesday September 03, 2013 @10:30AM
(#6321159)
Not necessarily. It's almost impossible for a CBO to get the best query plan for every query under every load under all data distributions. But the relational model is still beautiful, I find its limitations are minor in the grand scheme of things.
[ Parent
| on HN ]
Re:Easy Steps to a Complete Understanding of SQL
by jeffdavis on Tuesday September 03, 2013 @11:08AM
(#6321371)
"It's almost impossible for a CBO to get the best query plan for every query under every load under all data distributions."
It's also impossible for a human to do it. At least the optimizer will be awake at 3 in the morning and able to respond to data changes; the human will be asleep.