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: Collect statistics on small tables

By default, the database server creates statistics for tables with more than five rows. To create statistics for a table with less than five rows, use the CREATE STATISTICS statement.

Statistics gathered while processing one statement are available when searching for efficient ways to execute subsequent statements.