Explore >> Select a destination

You are here

 www.dbaglobe.com
Donghua's Blog - DBAGlobe: New Implementation for Nested Loop Joins (11g onwards)
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
1.7 parsecs away

Travel
| | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...
| | 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...
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
14.9 parsecs away

Travel
| [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.