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

Using primary keys to improve query performance Next Page

Using foreign keys to improve query performance

The following query lists the orders from the customer with customer ID 113:

FROM SalesOrders
WHERE CustomerID = 113;
Information on the Plan tab

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

SalesOrders <FK_CustomerID_ID>

Here FK_CustomerID_ID refers to the foreign key that the SalesOrders table has for the Customers table.