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.
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ...