User's Guide Part III. Using SQL AnywhereThis chapter describes some of the methods available in SQL Anywhere to monitor and improve the performance of your database.
Factors affecting database performance Using keys to improve query performance Using indexes to improve query performance Search strategies for queries from more than one table Sorting query results Temporary tables used in query processing How the optimizer works Monitoring database performance