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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Monitoring and improving performance


Performance improvement tips

SQL Anywhere provides excellent performance automatically. However, the following tips help you achieve the most from the product.

Acquire adequate hardware
Always use a transaction log
Check for concurrency issues
Choose the optimizer goal
Collect statistics on small tables
Declare constraints
Increase the cache size
Minimize cascading referential actions
Monitor query performance
Normalize your table structure
Review the order of columns in tables
Place different files on different devices
Rebuild your database
Reduce fragmentation
Reduce primary key width
Reduce table widths
Reduce requests between client and server
Reduce expensive user-defined functions
Replace expensive triggers
Strategic sorting of query results
Specify the correct cursor type
Supply explicit selectivity estimates sparingly
Turn off autocommit mode
Use an appropriate page size
Use appropriate data types
Use AUTOINCREMENT to create primary keys
Use bulk operations methods
Use delayed commits
Use in-memory mode
Use indexes effectively
Use keys to improve query performance
Use the cache to improve performance
Use the compression features
Use the WITH EXPRESS CHECK option when validating tables
Use work tables in query processing (use All-rows optimization goal)