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 22.1 shows the basic CREATE INDEX syntax. Refer to SQL Server 2014 Books Online for the full syntax.

LISTING 22.1 CREATE INDEX Syntax

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.