Microsoft SQL Server Tutorial => Create Clustered index

Download Microsoft SQL Server (PDF)

Fastest Entity Framework Extensions

Example

With a clustered index the leaf pages contain the actual table rows. Therefore, there can be only one clustered index.

CREATE TABLE Employees
(
    ID CHAR(900),
    FirstName NVARCHAR(3000),
    LastName NVARCHAR(3000),
    StartYear CHAR(900)
)
GO

CREATE CLUSTERED INDEX IX_Clustered 
ON Employees(ID)
GO

PDF - Download Microsoft SQL Server for free

Previous Next

Get monthly updates about new articles, cheatsheets, and tricks.