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

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

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.

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

For information on the Index Tuning Wizard, see the section "Index Tuning Wizard" in Books Online.