Sunday, August 29, 2004, 5:29:08 PM, Wolfgang Breitling (breitliw@xxxxxxxxxxxxx) 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@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 -----------------------------------------------------------------