To create an index on a table, you have to select on which columns to build the index, and then use the CREATE INDEX statement. As an example, to create the index called ndx_Customers_City on the City field of the Customers table, you must execute the statement of Listing 6.9.
USE Northwind GO CREATE INDEX ndx_Customers_City ON Customers(City)
You can use Enterprise Manager to create indexes on tables using the Manage Indexes form. To open the Manage Indexes form, you must display the list of tables in a database, select the table in which you ...