-
Introduction
Section titled “Introduction”The topic describes the EX0008 analysis rule.
EX0008: Generate CREATE INDEX statements for all columns included in foreign keys.
Section titled “EX0008: Generate CREATE INDEX statements for all columns included in foreign keys.”Message
Section titled “Message”Generate CREATE INDEX statements for all columns included in foreign keys.
Description
Section titled “Description”The rule checks for not indexed foreign keys in the current database and generated the appropriate CREATE INDEX statements.
The rule has a ContextOnly scope and is applied only on current server and database schema.
Parameters
Section titled “Parameters”| Name | Description | Default Value |
|---|---|---|
| MinimumRowsCount | Include only tables that have more than the specified minimum number of rows. | 0 |
Categories
Section titled “Categories”Explicit Rules
Additional Information
Section titled “Additional Information”There is no additional info for this rule.