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
Reducing fragmentation
Reducing file fragmentation
Reducing table fragmentation
Reducing index fragmentation and skew
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
Using the cache to improve performance
Limiting cache memory use
Dynamic cache sizing
Dynamic cache sizing on Windows
Dynamic cache sizing on Unix
Monitoring cache size
Using cache warming
Use the compression features
Use the WITH EXPRESS CHECK option when validating tables
Use work tables in query processing (use All-rows optimization goal)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |