OFSAA Global Performance Optimization

OFSAA execution performance can be enhanced by providing optimization parameters specifically at information domain level, database level, object level or object sub type level. This is done by updating the AAI_GLOBAL_EXEC_OPTIMIZATION table with appropriate values.

The columns and the values to be given in the AAI_GLOBAL_EXEC_OPTIMIZATION table are indicated as follows:

Table 12-1 Global Performance Optimization Name, Value, and their Description

Column Name	Description	Value
V_INFODOM_CODE	Information Domain code	ALL or specific information domain code.
V_DB_TYPE	Database type of the Information Domain	ORACLE or HIVE
V_OBJ_TYPE_CODE	Object type for which you want to apply execution optimization.	For example, Rule (RL). This is referred from AAI_OBJ_TYPE_SUBTYPE_MAP.V_ OBJ_TYPE_CODE.
V_OBJ_SUBTYPE_CODE	Object sub type for which you want to apply execution optimization.	For example, for Rule (RL) Object type, TYPE2 and TYPE3 are subtype codes. This is referred from AAI_OBJ_TYPE_SUBTYPE_MAP.V_ OBJ_SUBTYPE_CODE.
V_EXEC_OPTIM_PARAM_NAME	Name of the parameter using which optimization is done.	This is referred from AAI_EXEC_OPTIM_PARAM_B. V_EXEC_OPTIM_PARAM_NAME. Currently supported parameters are POSTSCRIPT, PRESCRIPT, MERGE, HINT and SELECT.
V_EXEC_OPTIM_PARAM_VALUE	Value for the optimization parameter mentioned in V_EXEC_OPTIM_PARAM_NAME column.