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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Performance improvements, diagnostics, and monitoring » Performance » Tips for improving performance

Tip: Declare constraints

Declaring primary key and foreign key relationships and their constraints can improve performance.

This is especially true when joins take place because the cost model is able to do a better job of estimation.

Not declaring the relationship can save time on index maintenance. Undeclared primary key-foreign key relationships exist between tables when there is an implied relationship between the values of columns in different tables.