You can create an index using the SQL Server 2000 Index Wizard, TRANSACT-SQL, or via the Enterprise Manager.
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):
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 ...