Notice
Recent Posts
Recent Comments
Link
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 |
8 | 9 | 10 | 11 | 12 | 13 | 14 |
15 | 16 | 17 | 18 | 19 | 20 | 21 |
22 | 23 | 24 | 25 | 26 | 27 | 28 |
29 | 30 |
Tags
- JavaScript
- ์นํผ๋ธ๋ฆฌ์ฑ
- database
- ๋ผํ๋ผ์ค์๋ง๋
- css
- Python
- ํ์ด์ฌ
- ๊นํ๋จ
- ๋ง์ผ๋ด๊ฐ์ธ์์๋ค์์ฐ๋ค๋ฉด
- K๋ฐฐํฐ๋ฆฌ๋ ๋ณผ๋ฃจ์
- ์ฑ
- ์ํ
- ๊ฐ๋ฐ
- ํ๋ก๊ทธ๋๋ฐ
- ์๋ฐ
- html
- ๋ฐ์ํ
- ์๋ฐ์คํฌ๋ฆฝํธ
- ๋ฐ์ดํฐ๋ฒ ์ด์ค
- K๋ฐฐํฐ๋ฆฌ
- ComputerScience
- ์ปดํจํฐ๊ณผํ
- ๊น๋ฏธ๊ฒฝ์๋งํ์์
- ์ฅํธ์์ค
- ์ฝ๋ฉ
- ๊น๋ฏธ๊ฒฝ
- ๋ ์
- Java
- ์นํ์ด์ง๋ง๋ค๊ธฐ
- ์ค๋ผํด
Archives
- Today
- Total
JiYoung Dev ๐ฅ
[database ๊ณ ๊ธ] ์ธ๋ฑ์ค (2023.08.09) ๋ณธ๋ฌธ
FULL SCAN
์ธ๋ฑ์ค
์ธ๋ฑ์ค ์์ฑ
CREATE INDEX IDX_PRD ON TB_PRD ( PRD_TYPE ) ;
์ธ๋ฑ์ค ์ฌ์ฉ ๋ชฉ์ : ์กฐํ ์ฑ๋ฅ ํฅ์
๋์ DML ์ฑ๋ฅ์ด ๊ฐ์ํจ
์ธ๋ฑ์ค ํ์ฉ : NL์กฐ์ธ (Nested Loop / ์ค์ฒฉ์กฐ์ธ)
์ธ๋ฑ์ค์ ํจ๊ป ์ฌ์ฉํ์ ๋ ํจ์จ์ด ๋์์ง
ํน์ง
- PRIMARY KEY ์์ฑ ==> ์์ด์ ๊ทธ PK์ ๋ํ ์ธ๋ฑ์ค ํ๋ ์์ฑ๋จ
๋ค๋ฅธ ๊ฒฝ์ฐ์๋ ์ง์ ์ธ๋ฑ์ค๋ฅผ ์์ฑํด์ผ ํจ
'full stack > database' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[database ๊ณ ๊ธ] ํ๋ก์์ (2023.08.09 ~ 10) (0) | 2023.08.09 |
---|---|
[database ๊ณ ๊ธ] ๊ณ์ธต ์ฟผ๋ฆฌ (2023.08.09) (0) | 2023.08.09 |
[database ๊ณ ๊ธ] ์๋์ฐ ํจ์ (2023.08.09) (0) | 2023.08.09 |
[database ๊ณ ๊ธ] ์งํฉ์ฐ์ฐ์ (2023.08.08) (0) | 2023.08.08 |
[database ๊ณ ๊ธ] CTAS (2023.08.08) (0) | 2023.08.08 |