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)
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |