This is just a short note on the parameter introduced in the 11gR2 called _connect_by_use_union_all. I’ve noticed it for the first time in Doc ID 7210630.8, which gives a brief overview of the changes made to the way CBO generates plans for hierarchical queries. As usually happens, the change helps to one problem, but produces [...]
-
Categories
-
Tags
10.2.0.4 10.2.0.5 10g 10gR2 11.2.0.2 11.2.0.3 11g 11gR2 ANSI SQL ASH AWR benchmark bug bug-or-feature CBQT coalesce subquery connect by dynamic views Exadata FBI funny stuff indexes join elimination join factorization memory MOS nested loops optimizer_features_enable opt_param ORA-04031 Oracle JVM PDML PX scripts shared cursors SPECjAppServer2004 sql_trace statistics Statspack subqueries subquery factoring tpt undocumented wait events wish list -
Top Posts
-
Blogroll
