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.
|
|
|
|
|
USE Study
|
|
|
|
|
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD>ε<EFBFBD><EFBFBD><EFBFBD>
|
|
|
|
|
|
CREATE UNIQUE INDEX idx_dname_unique
|
|
|
|
|
|
ON DEPARTMENT(DNAME)
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD>ε<EFBFBD><EFBFBD><EFBFBD>
|
|
|
|
|
|
CREATE INDEX idx_loc
|
|
|
|
|
|
ON DEPARTMENT(LOC)
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ε<EFBFBD><EFBFBD><EFBFBD>
|
|
|
|
|
|
CREATE INDEX idx_dno_salary
|
|
|
|
|
|
ON EMPLOYEE(DNO, SALARY)
|
|
|
|
|
|
|
|
|
|
|
|
-- DESCENDING INDEX
|
|
|
|
|
|
CREATE INDEX idx_dno_asc_salary_desc
|
|
|
|
|
|
ON EMPLOYEE(DNO, SALARY DESC)
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȹ
|
|
|
|
|
|
SELECT * FROM EMPLOYEE WHERE ENAME = 'e1'
|
|
|
|
|
|
|
|
|
|
|
|
CREATE INDEX idx_ename ON EMPLOYEE(ENAME)
|
|
|
|
|
|
|
|
|
|
|
|
SELECT * FROM EMPLOYEE WITH(INDEX = idx_ename) WHERE ENAME = 'e1' -- <EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD>ε<EFBFBD><EFBFBD><EFBFBD> <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
