/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: New Implementation for Nested Loop Joins (11g onwards)
| | sqlmaria.com
How to determine which view is the right view to use in Oracle?
1.5 parsecs away

Travel
| | Database views are a handy tool to help obfuscate complex joins from developers and analysts. However, knowing which view to use can be tricky, especially when faced with multiple views with simila...
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Explain Plan Lies
1.7 parsecs away

Travel
| |
| | connor-mcdonald.com
Kris Kringle the Database - Getting the BAND together - Learning is not a spectator sport
1.7 parsecs away

Travel
| | Ever heard of a BAND join? It's not actually new, it has been around since 12.2. Jonathan Lewis wrote up a nice post on it was back in 2017 but in a nutshell MERGE join done without a band join SQL> select 2 e1.last_name| ' has salary roughly between '| e2.last_name comparison 3 from 4...
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
11.8 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.