/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

 tanelpoder.com
Alter session force parallel query doesn't really force anything | Tanel Poder Blog
| | leonotes.wordpress.com
(transitive closure)?(Constraint-Generated Predicates) | LEO Notes
1.7 parsecs away

Travel
| | transitive closure?Wiki?Oracle?...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)
1.5 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.
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
1.9 parsecs away

Travel
| The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....