SQL guide For IBM Informix database servers 5.x, 7.x, 8.x, 9.x, 10.x, 11.x / Partially supported IBM Informix SQL features |
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: