/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 rwijk.blogspot.com
About Oracle: Filter predicates with NVL on mandatory columns using the index
| | oracletoday.blogspot.com
Oracle Today: Performance of Autotrace
1.1 parsecs away

Travel
| | I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
0.6 parsecs away

Travel
| | 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
FIRST_ROWS CURSOR_SHARING_EXACT | Oracle mechanics
1.4 parsecs away

Travel
| | 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...
| | sqlmaria.com
How to use a SQL Plan Baseline or a SQL Patch to add Optimizer hints
13.2 parsecs away

Travel
| 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...