논리 조인
• INNER JOIN
• OUTER JOIN (LEFT, RIGHT, FULL)
• CROSS JOIN
물리 조인
• HASH JOIN
• SORT MERGE JOIN
• NESTED LOOP JOIN
'Database' 카테고리의 다른 글
[Database] OUTER JOIN 이해 -(left outer join, right outer join, full outer join) (0) | 2023.06.06 |
---|
논리 조인
• INNER JOIN
• OUTER JOIN (LEFT, RIGHT, FULL)
• CROSS JOIN
물리 조인
• HASH JOIN
• SORT MERGE JOIN
• NESTED LOOP JOIN
[Database] OUTER JOIN 이해 -(left outer join, right outer join, full outer join) (0) | 2023.06.06 |
---|