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.