SQL SERVER 中创建索引的语句

–非聚集索引

CREATE INDEX au_id_ind

   ON authors (au_id)

–唯一聚集索引

CREATE UNIQUE CLUSTERED INDEX employeeID_ind

   ON emp_pay (employeeID)

–简单组合索引

CREATE INDEX emp_order_ind

   ON order_emp (orderID, employeeID)

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.