RE: More on Subquery Madness

  • From: "Justin Cave" <justin@xxxxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 27 Sep 2004 11:25:50 -0600

Reading Date's two replies, it seems that he reaches the opposite conclusion
in the later discussion-- SQL is unable to express certain relational
algebra concepts properly-- than he did originally-- Oracle's optimizer is
behaving incorrectly.  I don't see him say that he has changed his mind,
though...  Am I missing some subtlety here?

Justin Cave  
Distributed Database Consulting, Inc.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jonathan Gennick
Sent: Monday, September 27, 2004 9:00 AM
To: Oracle-L Freelists
Subject: More on Subquery Madness

Chris Date surprised me by writing some more on the topic:

I actually found his follow-up here more enlightening than
his first round of thoughts. It's a good, thought-provoking

Best regards,

Jonathan Gennick --- Brighten the corner where you are * 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, 
or send email to Oracle-article-request@xxxxxxxxxxx and 
include the word "subscribe" in either the subject or body.



Other related posts: