Use the following utility to tune the Adaptive Server:
qptune – enables you to fix missing statistics and identify the best query plan, optimization goal, or other configuration settings, and apply them at the query or server level.
