External optimizer directives

External directives that the SAVE EXTERNAL DIRECTIVES statement associates with the text of a query can improve performance in some queries for which the default behavior of the query optimizer is not satisfactory.

External optimizer directives are similar to inline optimizer directives that are embedded within a query. However, unlike inline directives, external directives can be applied without revising or recompiling existing applications.