Explore >> Select a destination
|
You are here 
|
blog.sqlora.com | ||
| | | | |
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... | |
| | | | |
oracle-randolf.blogspot.com
|
|
| | | | | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these... | |
| | | | |
sqlmaria.com
|
|
| | | | | At the recent OUG Ireland conference I had the privilege of participating in a panel discussion on the Oracle Database. During the course of the session the topic of Optimizer histograms came up. A... | |
| | | | |
hourim.wordpress.com
|
|
| | | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating... | ||
