Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: A Cure for Madness

Re[2]: A Cure for Madness

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 29 Aug 2004 20:03:06 -0400
Message-ID: <136994433609.20040829200306@gennick.com>


Sunday, August 29, 2004, 5:29:08 PM, Wolfgang Breitling (breitliw_at_centrexcc.com) wrote: WB> That's not what he says in the article. There he gives an "unequivocal no" WB> to the question whether it is valid to rewrite the query.

Date does not say that optimization, including merging, can't happen. Optimization is fine. I've never been opposed even to merging, so long as it is done in a way that preserves the "as if" results, meaning that the results still must be "as if" the subquery had been materialized, even though, in fact, it has not been. This is a reachable goal.

What Date says in his article is that the results of the optimization do not match the results that you get by following the conceptual process described in the language standard, and thus the optimization is flawed.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

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_at_gennick.com 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_at_freelists.org 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
Received on Sun Aug 29 2004 - 18:58:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US