A Cure for Madness
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 27 Aug 2004 17:19:43 -0400
Some of you might have read the article I recently posted on
"Subquery Madness!":
http://five.pairlist.net/pipermail/oracle-article/2004/000012.html
Chris Date took an interest in the issue, and he wrote a
fascinating follow-up, "A Cure for Madness," which just went
live today:
http://www.dbdebunk.com/page/page/1351381.htm
Please note that Chris is *not* saying that the subquery
results need to be materialized, but only that the final
results need to be "as if" they had been. I can think of at
least two ways to merge the subquery and yet maintain the
required "as if" behavior.
Chris's article is really clear and well-written. I wish I
could write as well as he does. I think you'll find his
article interesting no matter which side of the issue you
personally fall on.
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
