Explore >> Select a destination
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
tonyhasler.wordpress.com
|
|
| | | | | Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility... | |
| | | | |
iusoltsev.wordpress.com
|
|
| | | | | ??????? ?????? ?? ??????? ??????????? 465 ??????! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%????????%' OR A.LASTNAME LIKE '%????????%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ??? ???????, ????????? ???? ?? ??????? A.COMPANY_ID = 1 ???????? ??????? ???????????????? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT... | |
| | | | |
alexzeng.wordpress.com
|
|
| | | | | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use... | |
| | | | |
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... | ||
