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' -- °­Á¦ À妽º ÂüÁ¶