Turning on query acceleration

Before queries can be routed to the accelerator server for processing, you must set the use_dwa session environment variable.

Turn on acceleration by enabling the use_dwa session environment variable:

SET ENVIRONMENT USE_DWA 'accelerate on';

Setting the use_dwa 'accelerate on' option of the SET ENVIRONMENT statement of SQL enables the Informix® query optimizer to consider using the accelerator server to process the query when the optimizer generates the query plans. For a complete list of the use_dwa session environment variable options, see use_dwa session environment variable.