5. Designs Related to Improvement of Application Program Performance

This chapter explains designs related to improving application program performance.

Organization of this chapter

• 5.1 How to retrieve tables

• 5.2 B-tree indexes and text indexes used during execution of SQL statements

• 5.3 Range indexes used during execution of SQL statements

• 5.4 How to evaluate the search conditions when indexes are used

• 5.5 Table joining methods

• 5.6 How to process subqueries

• 5.7 Grouping methods

• 5.8 Methods for processing set operations

• 5.9 Method for processing SELECT DISTINCT

• 5.10 Considerations when executing an SQL statement that creates work tables

• 5.11 Equivalent exchange of search conditions

• 5.12 Considerations when searching an archivable multi-chunk table

• 5.13 Expanding internal derived tables

• 5.14 Improving performance by batch transfer of retrieval results

• 5.15 Batch transfer of dynamic parameter values

To Page Top