/
ํœ˜๋ฐœ์„ฑ ์ธ๋ฑ์Šค ์ƒ์„ฑ ๋ฐ ๊ด€๋ฆฌ

ํœ˜๋ฐœ์„ฑ ์ธ๋ฑ์Šค ์ƒ์„ฑ ๋ฐ ๊ด€๋ฆฌ

์ธ๋ฑ์Šค ์ƒ์„ฑ ๋ฐ ํ™œ์šฉ

ํœ˜๋ฐœ์„ฑ ํ…Œ์ด๋ธ”์€ ์‹ค์‹œ๊ฐ„ ๊ฒ€์ƒ‰์— ์ตœ์ ํ™”๋œ ๋ ˆ๋“œ๋ธ”๋ž™(RED-BLACK) ํŠธ๋ฆฌ๋ฅผ ๊ธฐ๋ณธ์œผ๋กœ ์ œ๊ณตํ•˜๊ณ  ์žˆ์œผ๋ฉฐ, ๋ชจ๋“  ๋ฐ์ดํ„ฐ ํƒ€์ž…์— ๋Œ€ํ•ด์„œ ์ธ๋ฑ์Šค๋ฅผ ์„ค์น˜ํ•  ์ˆ˜ ์žˆ๋‹ค. ๋‹จ, ํ•˜๋‚˜์˜ ์ปฌ๋Ÿผ์— ๋Œ€ํ•ด ํ•˜๋‚˜์˜ ์ธ๋ฑ์Šค๊ฐ€ ์ƒ์„ฑ ๊ฐ€๋Šฅํ•˜๋ฉฐ, ๋ณตํ•ฉ(composite) ์ธ๋ฑ์Šค๋Š” ์ œ๊ณตํ•˜์ง€ ์•Š๋Š”๋‹ค.

Mach> create volatile table vtable (id integer, name varchar(10));
Created successfully.
Mach> create index idx_vrb on vtable (name) index_type redblack;
Created successfuly.
Mach> desc vtable;
----------------------------------------------------------------
NAME                          TYPE                LENGTH        
----------------------------------------------------------------
ID                            integer             11              
NAME                          varchar             10                  

[ INDEX ]                              
----------------------------------------------------------------
NAME                          TYPE                COLUMN
----------------------------------------------------------------
IDX_VRB                       REDBLACK            NAME                
iFlux>

๊ธฐ๋ณธ ํ‚ค ์ธ๋ฑ์Šค

๋˜ํ•œ ํœ˜๋ฐœ์„ฑ ํ…Œ์ด๋ธ”์˜ ํŠน์ • ์ปฌ๋Ÿผ์— ๊ธฐ๋ณธ ํ‚ค๋ฅผ ๋ถ€์—ฌํ•˜๊ฒŒ ๋˜๋ฉด, ์—ฌ๊ธฐ์— ๋ ˆ๋“œ๋ธ”๋ž™ ํŠธ๋ฆฌ ์ธ๋ฑ์Šค๋ฅผ ์ž๋™์œผ๋กœ ์ƒ์„ฑํ•˜๊ฒŒ ๋œ๋‹ค. ์ด ๋•Œ๋Š” ์œ ์ผ์„ฑ(Uniqueness) ์†์„ฑ์„ ์ง€๋‹Œ ํŠน๋ณ„ํ•œ ์ธ๋ฑ์Šค๊ฐ€ ์ƒ์„ฑ๋˜๋ฉฐ ์ค‘๋ณต๋œ ๊ฐ’์„ ํ—ˆ์šฉํ•˜์ง€ ์•Š๋Š”๋‹ค.

Mach> create volatile table vtable (id integer primary key, name varchar(20));
Created successfully.
Mach> desc vtable;
----------------------------------------------------------------
NAME                          TYPE                LENGTH        
----------------------------------------------------------------
ID                            integer             11              
NAME                          varchar             20                  

[ INDEX ]                              
----------------------------------------------------------------
NAME                          TYPE                COLUMN
----------------------------------------------------------------
__PK_IDX_VTABLE               REDBLACK            ID   

iFlux>

ย 

๋‹ค๋ฅธ ์ธ๋ฑ์Šค ์œ ํ˜•

๋กœ๊ทธ ํ…Œ์ด๋ธ”์—์„œ ์‚ฌ์šฉํ•˜๋˜ ๋น„ํŠธ๋งต ํ˜น์€ ํ‚ค์›Œ๋“œ ์ธ๋ฑ์Šค๋Š” ํœ˜๋ฐœ์„ฑ ํ…Œ์ด๋ธ”์—์„œ ์‚ฌ์šฉํ•  ์ˆ˜ ์—†๋‹ค.

Mach> create bitmap   index idx_1237 on vtable(id1);
[ERR-02069 : Error in index for invalid table. BITMAP Index can only be created for LOG Table.]
Mach> create keyword  index idx_1238 on vtable(name);
[ERR-02069 : Error in index for invalid table. KEYWORD Index can only be created for LOG Table.]

Related content