All Days 무한도전

06/12 공인인증 RA DBMS 제주계정 튜닝

-- 설정 후 플랜정보 확인

SQL> set autot traceonly explain -- explain 설정

SQL> create index raclient_certi_idx on cjb.raclient(certi_number) nosegment;

SQL> exec dbms_stats.gather_table_stats(ownname => 'CJB', tabname => 'RACLIENT', estimate_percent=>10)

SQL> alter session set "_use_nosegment_indexes" = true;

-- 설정 해제

SQL> drop index raclient_certi_idx;

SQL> alter session set "_use_nosegment_indexes" = false;

-- 운영서버 반영

SQL> create index raclient_certi_idx on raclient(certi_number);