https://dbstudy.co.kr/w/index.php?action=history&feed=atom&title=SQL_%EC%A1%B0%EC%9D%B8_%EB%B0%A9%EC%8B%9D 2026-05-08T20:23:00Z 이 문서의 편집 역사 MediaWiki 1.39.10 https://dbstudy.co.kr/w/index.php?title=SQL_%EC%A1%B0%EC%9D%B8_%EB%B0%A9%EC%8B%9D&diff=1168&oldid=prev 2025-08-07T23:00:28Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ko"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← 이전 판</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2025년 8월 8일 (금) 08:00 판</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">3번째 줄:</td> <td colspan="2" class="diff-lineno">3번째 줄:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{:NL 조인|NL조인 (Nested Loop) }}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{:NL 조인|NL조인 (Nested Loop) }}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>----</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>----</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>{{:<del style="font-weight: bold; text-decoration: none;">해시 </del>조인 <del style="font-weight: bold; text-decoration: none;">HASH|해시조인 (Hash) </del>}}</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>{{:<ins style="font-weight: bold; text-decoration: none;">HASH </ins>조인}}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>----</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>----</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{:SORT MERGE 조인|소트머지조인 (Sort Merge)  }}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{:SORT MERGE 조인|소트머지조인 (Sort Merge)  }}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>----</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>----</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{:조인별 튜닝 포인트 }}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{:조인별 튜닝 포인트 }}</div></td></tr> </table>

Oracle https://dbstudy.co.kr/w/index.php?title=SQL_%EC%A1%B0%EC%9D%B8_%EB%B0%A9%EC%8B%9D&diff=1144&oldid=prev 2025-08-06T13:14:03Z

<p>새 문서: == SQL 조인 방식 == {{:NL 조인|NL조인 (Nested Loop) }} ---- {{:해시 조인 HASH|해시조인 (Hash) }} ---- {{:SORT MERGE 조인|소트머지조인 (Sort Merge) }} ---- {{:조인별 튜닝 포인트 }}</p> <p><b>새 문서</b></p><div>== SQL 조인 방식 ==<br /> <br /> {{:NL 조인|NL조인 (Nested Loop) }}<br /> ----<br /> {{:해시 조인 HASH|해시조인 (Hash) }}<br /> ----<br /> {{:SORT MERGE 조인|소트머지조인 (Sort Merge) }}<br /> ----<br /> {{:조인별 튜닝 포인트 }}</div>

Oracle