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 appropriate data types

You can improve performance by using the appropriate data type for your data.

Data types store information about specific sets of data, including ranges of values, the operations that can be performed on those values, and how the values are stored in memory. For instance, avoid assigning a data type of CHAR to values that only contain numeric data. And whenever possible, choose efficient data types over the more expensive numeric and string types.