Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Performance improvement tips » Use keys to improve query performance

Use keys to improve query performance Next Page

Using primary keys to improve query performance

A primary key improves performance on the following statement:

FROM Employees
WHERE EmployeeID = 390;
Information on the Plan tab

The Plan tab in the Results pane contains the following information:

Employees <Employees>

Whenever the name inside the parentheses on the Plan tab PLAN description is the same as the name of the table, it means that the primary key for the table is used to improve performance.