Explore >> Select a destination

You are here

 chandlerdba.com
SQL Patch, and a Parallel mistake - Neil Chandler's DB Blog
| | sqlmaria.com
How to use a SQL Plan Baseline or a SQL Patch to add Optimizer hints
2.0 parsecs away

Travel
| | In a recent chat with Connor McDonald, we discussed if it is realistic to have applications that don't contain Optimizer hints. Ideally, the answer to this question is "yes", you don't need hints i...
| | jonathanlewis.wordpress.com
Push Group by | Oracle Scratchpad
2.0 parsecs away

Travel
| | Jump to summary. A new optimizer feature that appears in 23c (probably not 21c) was the ability to push group by clauses into union all set operations. This will happen unhinted, but can be hinted with the highly memorable [no_]push_gby_into_union_all() hint that appeared in 23.1.0.0 according to v$sql_hint. and the feature can be disabled by...
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Explain Plan Lies
2.3 parsecs away

Travel
| |
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins
41.8 parsecs away

Travel
| A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.