Optimizer directives

IBM® Informix® SQL allows you to specify query optimization directives to force the query optimizer to use a different path than the implicit plan. With IBM Informix, optimizer directives are specified with the following SQL comment markers followed by a plus sign:

/*+ optimizer-directives */
{+  optimizer-directives }
--+ optimizer-directives

Genero BDL partially supports optimizer directives:

• The static SQL syntax does not allow the C-style optimizer syntax.
• The curly-brace and hyphen-hyphen optimizer directive syntaxes cannot be used in static SQL statements, because these correspond to the 4GL language comments.
• However, you can execute queries with optimization directives with Dynamic SQL.