PRB: Index Tuning Wizard May Not Recommend Indexes for SQL Statements in Triggers (270600)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q270600

SYMPTOMS

The Index Tuning Wizard may not analyze indexes for SQL statements in triggers.

CAUSE

Only SQL:SQLBatchCompleted events are passed to the Index Tuning Wizard. Trigger statements are logged as SQL:StmtCompleted events and so are not passed to the Index Tuning Wizard.

WORKAROUND

Invoke the Index Tuning Wizard from the Query Analyzer and tune the individual statements in the trigger code.

MORE INFORMATION

For information on the Index Tuning Wizard, see the section "Index Tuning Wizard" in Books Online.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbprb KB270600
©2003 Microsoft Corporation. All rights reserved.