Re[2]: More on Subquery Madness
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: "Justin Cave" <justin@xxxxxxxxxxx>
- Date: Mon, 27 Sep 2004 13:58:34 -0400
Monday, September 27, 2004, 1:25:50 PM, Justin Cave (justin@xxxxxxxxxxx) wrote:
JC> Reading Date's two replies, it seems that he reaches the opposite conclusion
JC> in the later discussion-- SQL is unable to express certain relational
JC> algebra concepts properly-- than he did originally-- Oracle's optimizer is
JC> behaving incorrectly.
I suspect he would say that both are true :-)
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@xxxxxxxxxxx and
include the word "subscribe" in either the subject or body.
Monday, September 27, 2004, 1:25:50 PM, Justin Cave (justin@xxxxxxxxxxx) wrote:
JC> Reading Date's two replies, it seems that he reaches the opposite conclusion
JC> in the later discussion-- SQL is unable to express certain relational
JC> algebra concepts properly-- than he did originally-- Oracle's optimizer is
JC> behaving incorrectly. I don't see him say that he has changed his mind,
JC> though... Am I missing some subtlety here?
JC> Justin Cave
JC> Distributed Database Consulting, Inc.
JC> http://www.ddbcinc.com/askDDBC
JC> -----Original Message-----
JC> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
JC> On Behalf Of Jonathan Gennick
JC> Sent: Monday, September 27, 2004 9:00 AM
JC> To: Oracle-L Freelists
JC> Subject: More on Subquery Madness
JC> Chris Date surprised me by writing some more on the topic:
JC> http://www.dbdebunk.com/page/page/1409199.htm
JC> x
JC> I actually found his follow-up here more enlightening than
JC> his first round of thoughts. It's a good, thought-provoking
JC> read.
JC> Best regards,
JC> Jonathan Gennick --- Brighten the corner where you are
JC> http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
JC> Join the Oracle-article list and receive one
JC> article on Oracle technologies per month by
JC> email. To join, visit
JC> http://five.pairlist.net/mailman/listinfo/oracle-article,
JC> or send email to Oracle-article-request@xxxxxxxxxxx and
JC> include the word "subscribe" in either the subject or body.
JC> --
JC> //www.freelists.org/webpage/oracle-l
JC> --
JC> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
