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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Performance and Optimization

UltraLite Performance and Optimization Next Page

Optimizing UltraLite query performance

UltraLite provides excellent SQL query performance automatically. The way in which UltraLite implements 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