A Cure for Madness 2004-08-27 - By Jonathan Gennick
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@(protected)
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@(protected) 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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
