Sorted Hash Cluster

▣ Sorted Hash Cluster

Index cluster의 장점과 Hash Cluster 의 장점을 모아서 구현

   

▣ Sorted Hash Cluster : Basic Architecture

   

▣ Sorted Hash Cluster : Example

▶ ex) 본체

CREATE CLUSTER calls_cluster (

orgin_number NUMBER,

call_timestamp NUMBER SORT)

HASHKEYS 10000 => Maximum 값

SINGLE TABLE HASH IS origin_number

SIZE 50;

▶ ex) 카드

CREATE TABLE calls (

origin_number NUMBER,

call_timestamp NUMBER,

other_info VARCHAR2(30))

CLUSTER calls_cluster (

origin_number,call_timestamp);