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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » Planning and Design » UltraLite performance and optimization


Optimizing UltraLite query performance

UltraLite provides excellent SQL query performance automatically. 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
Managing temporary tables
Using direct page scans