ASA SQL User's Guide
Monitoring and Improving Performance
Adaptive Server Anywhere provides excellent performance automatically. However, the following tips will help you achieve the most from the product.
Always use a transaction log
Increase the cache size
Normalize your table structure
Use indexes effectively
Place different files on different devices
Turn off autocommit mode
Use bulk operations methods
Use the WITH EXPRESS CHECK option when validating tables
Try using Adaptive Server Anywhere's compression features
Reduce the number of requests between client and server
Reduce table widths
Reduce primary key width
Declare constraints
Use appropriate data types
Use AUTOINCREMENT to create primary keys
Replace expensive triggers
Minimize cascading referential actions
Pay attention to the order of columns
Upgrade to take advantage of new features
Rebuild your database
Examine your database and server configurations
Use an appropriate page size
Examine file, table, and index fragmentation
Acquire adequate hardware
Choose the Optimizer's priority
Specify the correct cursor type
Consider collecting statistics on small tables
Use user-estimates sparingly
Reduce expensive user-defined functions