Creating Indexes

SQL Server automatically creates an index for the PRIMARY KEY and UNIQUE constraints. If you want other indexes, you must create them.

    To create an index

• In SQL Enterprise Manager's Server Manager window, select the appropriate table, click the right mouse button, and then choose Indexes.

  (For details, search for "indexes" in SQL Enterprise Manager Help.)

Or

• Use the CREATE INDEX statement.

  For example:

  CREATE UNIQUE CLUSTERED INDEX au_id_ind
  ON authors (au_id)

  creates an index on the au_id column of the authors table to enforce uniqueness.

  (For details, see the CREATE INDEX statement in the Microsoft SQL Server Transact-SQL Reference.)