How to create a new index (Query Analyzer)

To create a new index

  1. On the Query menu, click Show Execution Plan.
  2. Execute the Transact-SQL script in the query pane.
  3. In the result pane, click the Execution Plan tab.
  4. Right-click the icon of the physical operator that suggests that an index needs to be created, and then click Manage Indexes.... The database and table that the Graphical Execution Plan suggests need an index are automatically selected. Click New....
  5. In Index name, enter the name for the index.
  6. In Column, select the column to appear in the index. Composite indexes can be created by selecting more than one column.
  7. Optionally, select a column, and then click either Move Up or Move Down to change the order of the columns in the index.
  8. Optionally, in Index options, select:
  9. Optionally, click Edit SQL... to view and edit the Transact-SQL statement used to create the index.
See Also
Graphically Displaying the Execution Plan Using SQL Server Query Analyzer Placing Indexes on Filegroups

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.