Explore >> Select a destination
|
You are here 
|
oracle-randolf.blogspot.com | ||
| | | | |
www.xt-r.com
|
|
| | | | | ?????? ????? ???? ????? ?? 11.2.0.3 ? ?????? ??????(V$SQL_HINT), ????? ?????? ?? ???????? ? ???? ??????? ???????, ??????? ??????????? ??????... | |
| | | | |
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... | |
| | | | |
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... | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | I've lost count of the number of times I've reminded people that hinting (correctly) is hard. Even the humble /*+ index() */ hint and its close relatives are open to misunderstanding and accidental misuse, leading to complaints that "Oracle is ignoring my hint". Strange though it may seem, I'm still not 100% certain of what... | ||
