SA0049 : Table does not have a clustered index

The topic describes the SA0049 analysis rule.

Message

Table does not have a clustered index

Description

The rule checks all the tables in the current database for having a clustered index defined.

How to fix

Create a clustered index for the reported table.

Scope

The rule has a ContextOnly scope and is applied only on current server and database schema.

Parameters

Rule has no parameters.

Remarks

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Effort To Fix
5 minutes per issue.
Categories

Performance Rules, Bugs

Additional Information

There is no additional info for this rule.

See Also

Other Resources