Microsoft® SQL Server 2012 Unleashed

Creating Indexes with T-SQL

Transact-SQL (T-SQL) is the most fundamental means for creating an index. This method was available in all previous versions of SQL Server. It is a very powerful option for creating indexes because the T-SQL statements that create indexes can be stored in a file and run as part of a database installation or upgrade. In addition, T-SQL scripts that were used in prior SQL Server versions to create indexes can be reused with very little change.

You can create indexes by using the T-SQL CREATE INDEX command. Listing 21.1 shows the basic CREATE INDEX syntax. Refer to SQL Server 2012 Books Online for the full syntax.

LISTING 21.1 CREATE INDEX Syntax

Click here to view code image

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ...