A Look at Three Join Methods: Hash, Merge, Nested Loops
In this episode of Ask TOM Office Hours, we looked at the three join methods:
* Hash joins
* Merge joins
* Nested loops
We covered how these work and their relative strengths and weaknesses
Highlights include:
02:35 - Example queries for unindexed joins
10:30 - How a hash join works
13:40 - How a merge join works
21:05 - How a nested loop works
28:35 - Example joins in top-N queries
45:15 - How indexes affect joins
49:00 - Example joins wheen filtering one table
52:10 - How adaptive plans work
53:30 - Summary; time complexity of the joins, how indexes affect them, and their optimal use case
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
Видео A Look at Three Join Methods: Hash, Merge, Nested Loops канала Oracle Developers
* Hash joins
* Merge joins
* Nested loops
We covered how these work and their relative strengths and weaknesses
Highlights include:
02:35 - Example queries for unindexed joins
10:30 - How a hash join works
13:40 - How a merge join works
21:05 - How a nested loop works
28:35 - Example joins in top-N queries
45:15 - How indexes affect joins
49:00 - Example joins wheen filtering one table
52:10 - How adaptive plans work
53:30 - Summary; time complexity of the joins, how indexes affect them, and their optimal use case
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
Видео A Look at Three Join Methods: Hash, Merge, Nested Loops канала Oracle Developers
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Back to the basics of DB security - Database rolesBuild a Geo-Distributed Serverless App using Oracle NoSQL Database Cloud ServiceKey Vault with ExaCC, Oracle Data Safe's OCI native migration is completeBuilding Multicloud Serverless Applications with Micronaut and GraalVMBloom filters, hash joins and why indexing should scare youEpisode 12: Formulaπ Drives!Visual Builder New Features: August 2021 - 21.10 ReleaseAdvanced Chatbot Development - the Art of What’s PossibleApp simple: The future of data-centric app devHeat MapSecurity Basics - Passwords and the Oracle DatabaseJSON and SODA with the Autonomous JSON Database - AmericasTerraforming the Cloud with Oracle Cloud Infrastructure Resource ManagerVanity URL Extensions for APEX and ORDS on Oracle Autonomous DatabaseMachine Learning in Oracle Autonomous Data Warehouse#PiDay | Wojciech & Ignacio | Enhancing your gaming experience with a real-time dashboardVisual Builder Office Hours: Dynamic Components In Depth OverviewAPEX App Creator Spotlight: How Michelle Skamene's Reading Rewards grew to half a million usersBuild a Fully Functional APEX App from a Spreadsheet in 45 minutes!Visual Builder - What’s NewReal-world Low Code: Four partners show how they deliver solutions using Oracle APEX!