O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Indexes

Indexes can be created either via SQL Server Management Studio using the graphical user interface (GUI) or via command line tools. SQL Server Management Studio is convenient because of its ease of use. The GUI can generate a script that you can then modify and reuse. However, I prefer to create indexes using the command line option because these scripts can be reused and modified to create other similar indexes. In addition, these scripts are an excellent way to document your database. If there is a problem with indexes and you needed to recreate them, these scripts can be used to create all indexes in the database. One way to do this is to use the GUI to create the first index, have the GUI generate a script, and then modify ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required