|
You are here |
rwijk.blogspot.com | ||
| | | | |
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... | |
| | | | |
www.dbaglobe.com
|
|
| | | | | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc. | |
| | | | |
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... | |
| | | | |
blog.tanelpoder.com
|
|
| | | Advanced Oracle SQL Tuning, Troubleshooting and Linux Performance Training by Tanel Poder - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | ||