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: Use AUTOINCREMENT to create primary keys

Using the AUTOINCREMENT feature to generate primary key values is faster than other methods because the value is generated by the database server.

You can use the AUTOINCREMENT default for any column in which you want to maintain unique values.