/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
How to resolve SQL object and column names all the way to base tables and columns in Oracle? | Tanel Poder Consulting
| | rwijk.blogspot.com
About Oracle: Filter predicates with NVL on mandatory columns using the index
1.7 parsecs away

Travel
| |
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)
1.2 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.
| | oracleprof.blogspot.com
Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines
1.4 parsecs away

Travel
| | SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...
| | connor-mcdonald.com
Kris Kringle the Database - Getting the BAND together - Learning is not a spectator sport
15.6 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...