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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Using UltraLite databases

 

UltraLite performance and optimization

UltraLite provides excellent SQL query performance. Index scans, direct page scans, and temporary tables are internal optimization techniques that help you to achieve the most from the product. However, you can further tune these features, depending on the results of any query performance tests you run.


Using index scans
Determining the access method used by the optimizer
Tuning query performance with index hashing
Choosing an optimal hash size
Setting the maximum hash size
Managing temporary tables
Flushing single or grouped transactions
How database encryption and obfuscation affect performance