如何创建索引?

Question

如何创建索引?

Answer 1

在联机帮助里面查询：create index

Answer 2

CREATE INDEX (Transact-SQL)
http://technet.microsoft.com/zh-cn/library/ms188783.aspx
------------------------
USE AdventureWorks;
GO
IF EXISTS (SELECT name FROM sys.indexes
            WHERE name = N'IX_ProductVendor_VendorID')
    DROP INDEX IX_ProductVendor_VendorID ON Purchasing.ProductVendor;
GO
CREATE INDEX IX_ProductVendor_VendorID 
    ON Purchasing.ProductVendor (VendorID); 
GO

Answer 3

http://topic.csdn.net/u/20080515/16/6f359854-5403-4397-89e3-b1b8dd71d527.html