[GOLDILOCKS] Global Secondary Index 추가, 삭제하기

GOLDILOCKS 는 클러스터 환경에서 Row Identifier 를 위해 Global Secondary Index 를 지원합니다.

Global Secondary Index 란?

http://mozi.tistory.com/99?category=999095

테이블에 Global Secondary Index 가 없는 경우,

LIMIT FETCH 와 같은 쿼리가 수행되지 않습니다.

Global Secondary Index 유무 확인하기

gSQL> SELECT TABLE_OWNER, TABLE_SCHEMA, TABLE_NAME FROM ALL_GSI_PLACE;

TABLE_OWNER TABLE_SCHEMA      TABLE_NAME
----------- ----------------- ------------------------
SYS         DICTIONARY_SCHEMA DBC_TABLE_TYPE_INFO
SYS         DICTIONARY_SCHEMA DBC_TABLE_TYPE_INFO
SYS         DICTIONARY_SCHEMA JDBC_CLIENT_PROPS
SYS         DICTIONARY_SCHEMA JDBC_CLIENT_PROPS
SYS         DICTIONARY_SCHEMA IMPLEMENTATION_INFO_BASE
SYS         DICTIONARY_SCHEMA IMPLEMENTATION_INFO_BASE
TEST        PUBLIC            T1
TEST        PUBLIC            T1
TEST        PUBLIC            T2
TEST        PUBLIC            T2
TEST        PUBLIC            T3
TEST        PUBLIC            T3
TEST        PUBLIC            T4
TEST        PUBLIC            T4
TEST        PUBLIC            T5
TEST        PUBLIC            T5

16 rows selected.

Global Secondary Index 추가

gSQL> ALTER TABLE PUBLIC.T1 ADD GLOBAL SECONDARY INDEX;

Table altered.

Global Secondary Index 삭제

gSQL> ALTER TABLE PUBLIC.T1 DROP GLOBAL SECONDARY INDEX;

Table altered.