You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
485 B
25 lines
485 B
USE Study
|
|
GO
|
|
|
|
-- 고유 인덱스
|
|
CREATE UNIQUE INDEX idx_dname_unique
|
|
ON DEPARTMENT(DNAME)
|
|
|
|
-- 비고유 인덱스
|
|
CREATE INDEX idx_loc
|
|
ON DEPARTMENT(LOC)
|
|
|
|
-- 결합인덱스
|
|
CREATE INDEX idx_dno_salary
|
|
ON EMPLOYEE(DNO, SALARY)
|
|
|
|
-- DESCENDING INDEX
|
|
CREATE INDEX idx_dno_asc_salary_desc
|
|
ON EMPLOYEE(DNO, SALARY DESC)
|
|
|
|
-- 실행계획
|
|
SELECT * FROM EMPLOYEE WHERE ENAME = 'e1'
|
|
|
|
CREATE INDEX idx_ename ON EMPLOYEE(ENAME)
|
|
|
|
SELECT * FROM EMPLOYEE WITH(INDEX = idx_ename) WHERE ENAME = 'e1' -- 강제 인덱스 참조 |