/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

 www.dbaglobe.com
Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins
| | www.bobbydurrettdba.com
Cardinality errors across joins | Bobby Durrett's DBA Blog
2.4 parsecs away

Travel
| | We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...
| | optimizermagic.blogspot.com
Inside the Oracle Optimizer - Removing the black magic: What's Changed between my New Query Plan and the Old One?
2.2 parsecs away

Travel
| | This blog post has moved here http://blogs.oracle.com/optimizer/entry/whats_changed_between_my_new_query_plan_and_the_old_one
| | tanelpoder.com
Advanced Oracle SQL Tuning Training | Tanel Poder Blog
2.6 parsecs away

Travel
| | Training overview This training session is entirely about making Oracle SQL execution run faster and more efficiently, understanding the root causes of SQL performance problems and Cost Based Optimizer misbehavior. Instead of looking into increasing system utilization (by using more buffer cache or more parallelism) as a first "tuning" choice, this class is mostly about decreasing resource usage of SQL execution plans by improving their shape and available access paths. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
17.1 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.