/explore
|
You are here 
|
chandlerdba.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... |
|
| | | | | ||
| | | | |
sqlmaria.com
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... |
|
| | | | | ||
| | | | |
orastory.wordpress.com
There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID).... |
|
| | | | | ||
| | | | |
afatkulin.blogspot.com
Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod... |
|
| | | |||
