/
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
์ธ๋ฑ์ค ์์ฑ ๋ฐ ํ์ฉ
ํ๋ฐ์ฑ ํ ์ด๋ธ์ ์ค์๊ฐ ๊ฒ์์ ์ต์ ํ๋ ๋ ๋๋ธ๋(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
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
More like this
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
More like this
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
More like this
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
More like this
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
ํ๋ฐ์ฑ ์ธ๋ฑ์ค ์์ฑ ๋ฐ ๊ด๋ฆฌ
More like this
Creating and Managing Volatile Index
Creating and Managing Volatile Index
More like this