Oracle-SQL-Tuning

친절한 SQL 튜닝을 읽고, Oracle DB 구축 및 SQL tuning을 실습하며 기록하는 레포지토리입니다.

Oracle Database Version : 19c

Contents

• Install & Connect Oracle DB on an M1 Mac
• ERD & DDL, Dummy Data Insertion
• Index Basic

References

• Oracle 19c Functions
• Oracle 19c Optimizer Hints
• Oracle 19c Optimizer Access Paths

Frequently Used Queries

ALTER SYSTEM FLUSH BUFFER_CACHE;

ALTER SYSTEM FLUSH SHARED_POOL;

CREATE INDEX INDEX_NAME
    ON TABLE_NAME (COLUMN_1, COLUMN_2, ..);

ALTER INDEX INDEX_NAME REBUILD;

DROP INDEX INDEX_NAME;