Turning on query acceleration
Before queries can be routed to the accelerator server
for processing, you must set the use_dwa session
environment variable.
About this task
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.