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 25.1 shows the basic CREATE INDEX syntax. Refer to SQL Server 2008 Books Online for the full syntax.
Listing 25.1 CREATE INDEX Syntax
Table 25.1 lists the CREATE INDEX arguments.
Table 25.1 Arguments for ...
Get Microsoft® SQL Server 2008 R2 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.
