A Look at Three Join Methods: Hash, Merge, Nested Loops
16.5 هزار بار بازدید -
5 سال پیش
-
In this episode of Ask
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.
asktom.oracle.com/
Oracle Developers portal: developer.oracle.com/
Sign up for an Oracle Cloud trial: cloud.oracle.com/en_US/tryit
5 سال پیش
در تاریخ 1398/11/02 منتشر شده
است.
16,582
بـار بازدید شده