1 ͺ̽
ùٸ
̺ ȭ (normalization)
ùٸ ε
Ŭ , Ŭ (MDC)
뷮 Ͽ콺 , ͺ̽ ƼŴ
ǥ , ̺ ƼŴ
UAV (Union All View) Ƽ
ͺ̽, ̺ MDC Ƽ
̺ Ƽ MDC - -ƿ
MQT (Materialized query table) Ȱ
ͺ̽ 踦 ϴ
2 Ʃ ͺ̽ ȭ
DB2 SQL ùٸ ۼ
SQL ͺ̽
Explain ̿ SQL Ʃ
3 DB2 ͺ̽ ʱ ȿ
DB2 ġ ü
I/O
DB2 Ʈ
ý ̾ƿ
νϽ
ͺ̽
Ǯ ̺ ̽
۾
뼺
4 뷮 Ϳ Ͽ콺 ȯ濡 ȭ
ͺ̽ ƼŴ ȯ (DPF) ⺻
Ͽ콺
̺ ƼŴ(Table Partitioning)
Ƽ ùٸ Ǵ
ȹ м