/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

 optimizermagic.blogspot.com
Inside the Oracle Optimizer - Removing the black magic: Maintaining statistics on large partitioned tables
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Oracle Exadata - Storage Indexes
4.6 parsecs away

Travel
| | [AI summary] An Oracle DBA explores and demonstrates the performance benefits of Exadata Storage Indexes, specifically highlighting their ability to handle NULL values efficiently through SQL query tests.
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins
4.0 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.
| | sqlmaria.com
Optimizer Histograms
2.3 parsecs away

Travel
| | At the recent OUG Ireland conference I had the privilege of participating in a panel discussion on the Oracle Database. During the course of the session the topic of Optimizer histograms came up. A...
| | orastory.wordpress.com
SQL_IDs and baselines | OraStory
14.6 parsecs away

Travel
| There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....