O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

How to Create Indexes

You can create an index using the SQL Server 2000 Index Wizard, TRANSACT-SQL, or via the Enterprise Manager.

NOTE

You cannot create an index on the following data types:

bit 
text
image

New for SQL Server 2000 is index creation on a view and a computed column.

Using the SQL Enterprise Manager, select a server and then click the Wizards icon from the toolbar. The Wizard Selection dialog box appears. Expand the Database options by clicking on the + sign. Then follow these steps to create an index (the following example uses the pubs database):

1.
Select the Create Index Wizard from the Wizard Selection dialog box. The Create Index Wizard Welcome dialog box appears (see Figure 18.8).
Figure 18.8. The Create Index Wizard ...

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