https://dbstudy.co.kr/w/index.php?action=history&feed=atom&title=SQL_%ED%8A%9C%EB%8B%9D_%EC%9E%85%EB%AC%B8
SQL 튜닝 입문 - 편집 역사
2026-11-04T06:03:57Z
이 문서의 편집 역사
MediaWiki 1.39.10
https://dbstudy.co.kr/w/index.php?title=SQL_%ED%8A%9C%EB%8B%9D_%EC%9E%85%EB%AC%B8&diff=1991&oldid=prev
Dbstudy: 상단 배너를 {{타이틀 주제}} 틀로 교체
2026-11-04T04:26:20Z
<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;">2026년 11월 4일 (수) 13:26 판</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">1번째 줄:</td>
<td colspan="2" class="diff-lineno">1번째 줄:</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;"><div style="background:linear-gradient(135deg,#4a0e0e 0%,#8e1b1b 55%,#c0392b 100%);color:#ffffff;padding:32px 36px;border-radius:14px;margin-bottom:24px;box-shadow:0 4px 14px rgba(74,14,14,0.25);"></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;">{{타이틀 주제</ins></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;"><div style</del>=<del style="font-weight: bold; text-decoration: none;">"font-size:12px;letter-spacing:3px;opacity:0.8;margin-bottom:6px;"></del>ORACLE SQL TUNING · FOUNDATION COURSE<del style="font-weight: bold; text-decoration: none;"></div></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;">|부제 </ins>= ORACLE SQL TUNING · FOUNDATION COURSE</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;"><div style</del>=<del style="font-weight: bold; text-decoration: none;">"font-size:30px;font-weight:700;line-height:1.3;"></del>SQL 튜닝 입문<del style="font-weight: bold; text-decoration: none;"></div></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;">|제목 </ins>= SQL 튜닝 입문</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;"><div style</del>=<del style="font-weight: bold; text-decoration: none;">"font-size:15px;opacity:0.92;margin-top:10px;line-height:1.7;"></del>SQL이 처리되는 원리부터 실행계획 읽기, 인덱스·조인 튜닝, 진단 도구까지<br/>Oracle 기반으로 처음 시작하는 사람을 위한 단계별 가이드<del style="font-weight: bold; text-decoration: none;"></div></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;">|설명 </ins>= SQL이 처리되는 원리부터 실행계획 읽기, 인덱스·조인 튜닝, 진단 도구까지<br/>Oracle 기반으로 처음 시작하는 사람을 위한 단계별 가이드</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;"><div style</del>=<del style="font-weight: bold; text-decoration: none;">"margin-top:18px;display:flex;flex-wrap:wrap;gap:8px;"></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;">|색상 </ins>= <ins style="font-weight: bold; text-decoration: none;">빨강</ins></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;"><span style</del>=<del style="font-weight: bold; text-decoration: none;">"background:rgba(255,255,255,0.15);border:1px solid rgba(255,255,255,0.3);padding:4px 12px;border-radius:20px;font-size:12px;"></del>난이도 · 입문<del style="font-weight: bold; text-decoration: none;"></span></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;">|배지1 </ins>= 난이도 · 입문</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;"><span style</del>=<del style="font-weight: bold; text-decoration: none;">"background:rgba(255,255,255,0.15);border:1px solid rgba(255,255,255,0.3);padding:4px 12px;border-radius:20px;font-size:12px;"></del>학습기간 · 12주<del style="font-weight: bold; text-decoration: none;"></span></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;">|배지2 </ins>= 학습기간 · 12주</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;"><span style</del>=<del style="font-weight: bold; text-decoration: none;">"background:rgba(255,255,255,0.15);border:1px solid rgba(255,255,255,0.3);padding:4px 12px;border-radius:20px;font-size:12px;"></del>기준 DBMS · Oracle 19c<del style="font-weight: bold; text-decoration: none;"></span></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;">|배지3 </ins>= 기준 DBMS · Oracle 19c</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;"><span style</del>=<del style="font-weight: bold; text-decoration: none;">"background:rgba(255,255,255,0.15);border:1px solid rgba(255,255,255,0.3);padding:4px 12px;border-radius:20px;font-size:12px;"></del>선수 학습 · SQL 기초, [[데이터 모델링 입문]]<del style="font-weight: bold; text-decoration: none;"></span></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;">|배지4 </ins>= 선수 학습 · SQL 기초, [[데이터 모델링 입문]]</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;"></div></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;">}}</ins></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;"></div></del></div></td><td colspan="2" class="diff-side-added"></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;"><br/></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;"><br/></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 style="display:flex;flex-wrap:wrap;gap:14px;margin-bottom:26px;"></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 style="display:flex;flex-wrap:wrap;gap:14px;margin-bottom:26px;"></div></td></tr>
</table>
Dbstudy
https://dbstudy.co.kr/w/index.php?title=SQL_%ED%8A%9C%EB%8B%9D_%EC%9E%85%EB%AC%B8&diff=1981&oldid=prev
2026년 11월 4일 (수) 03:54에 Dbstudy님의 편집
2026-11-04T03:54:13Z
<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;">2026년 11월 4일 (수) 12:54 판</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l713">713번째 줄:</td>
<td colspan="2" class="diff-lineno">713번째 줄:</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;"><br/></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;"><br/></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 style="margin-top:30px;padding:14px 20px;border-top:3px solid #4a0e0e;background:#faf5f4;border-radius:0 0 10px 10px;font-size:13px;color:#5a4a4a;"></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 style="margin-top:30px;padding:14px 20px;border-top:3px solid #4a0e0e;background:#faf5f4;border-radius:0 0 10px 10px;font-size:13px;color:#5a4a4a;"></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>'''선수 학습''' ← [[데이터 모델링 입문]] · [[Oracle 물리 설계]] &nbsp;|&nbsp; '''다음 학습''' → [[실행계획 읽기 실습]] · [[인덱스 튜닝 심화]] · [[조인 튜닝 심화]] · [[AWR 리포트 분석]]</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>'''선수 학습''' ← [[데이터 모델링 입문]] · [[Oracle <ins style="font-weight: bold; text-decoration: none;">DB </ins>물리 설계]] &nbsp;|&nbsp; '''다음 학습''' → [[실행계획 읽기 실습]] · [[인덱스 튜닝 심화]] · [[조인 튜닝 심화]] · [[AWR 리포트 분석]]</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></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></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;"><br/></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;"><br/></td></tr>
</table>
Dbstudy
https://dbstudy.co.kr/w/index.php?title=SQL_%ED%8A%9C%EB%8B%9D_%EC%9E%85%EB%AC%B8&diff=1980&oldid=prev
Dbstudy: 새 문서: <div style="background:linear-gradient(135deg,#4a0e0e 0%,#8e1b1b 55%,#c0392b 100%);color:#ffffff;padding:32px 36px;border-radius:14px;margin-bottom:24px;box-shadow:0 4px 14px rgba(74,14,14,0.25);"> <div style="font-size:12px;letter-spacing:3px;opacity:0.8;margin-bottom:6px;">ORACLE SQL TUNING · FOUNDATION COURSE</div> <div style="font-size:30px;font-weight:700;line-height:1.3;">SQL 튜닝 입문</div> <div style="font-size:15px;opacity:0.92;margin-top:10px;line-height:1.7;">SQL...
2026-11-04T03:47:28Z
<p>새 문서: <div style="background:linear-gradient(135deg,#4a0e0e 0%,#8e1b1b 55%,#c0392b 100%);color:#ffffff;padding:32px 36px;border-radius:14px;margin-bottom:24px;box-shadow:0 4px 14px rgba(74,14,14,0.25);"> <div style="font-size:12px;letter-spacing:3px;opacity:0.8;margin-bottom:6px;">ORACLE SQL TUNING · FOUNDATION COURSE</div> <div style="font-size:30px;font-weight:700;line-height:1.3;">SQL 튜닝 입문</div> <div style="font-size:15px;opacity:0.92;margin-top:10px;line-height:1.7;">SQL...</p>
<a href="https://dbstudy.co.kr/w/index.php?title=SQL_%ED%8A%9C%EB%8B%9D_%EC%9E%85%EB%AC%B8&diff=1980">차이 보기</a>
Dbstudy