Tuning: Improving query speed

Most performance degradation occurs during queries. An inefficient query can adversely affect the performance of your system by allocating resources that are not always needed. Queries can be tuned to perform more efficiently so that the engine is not required to search entire files to determine which records match the query. Other factors that can affect the performance of file system searches include key design, key selection algorithms, and number of records.

Key type definitions
Troubleshooting: Database debug
Troubleshooting: Slow execution of queries
Tuning: Designing keys for queries
Tuning: Key selection algorithms
Tuning: Number of fields in files