Explore >> Select a destination
|
You are here 
|
leonotes.wordpress.com | ||
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
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... | |
| | | | |
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
|
|
| | | Another little warning for those about to upgrade from 9i to 10g. Some hints will change their behaviour. Consider the following SQL. By default if Oracle cannot unnest a subquery it postpones execution of that subquery to the end of the execution plan. I've used the no_unnest hint in the subquery to stop Oracle from... | ||
