Explore >> Select a destination
|
You are here 
|
savvinov.com | ||
| | | | |
www.dbaglobe.com
|
|
| | | | | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | 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... | |
| | | | |
dioncho.wordpress.com
|
|
| | | | | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | A couple of weeks ago, having just arrived home from Spain, I got a phone call in Heathrow airport from an old client that I hadn't seen for about 18 months. They had a problem; as far as they could tell a business critical query had suddenly stopped using an index and was doing a... | ||
