Transact-SQL Performance Issues

When you analyze the Transact-SQL code in your database project, one or more warnings might be categorized as performance issues. You should address a performance issue to avoid the following situation:

  • A table scan will occur when the code is executed.

In general, you might suppress a performance issue if the table contains so little data that a scan will not cause performance to drop significantly.

In This Section

Visual Studio Premium identifies the following design issues: