7.10.1 Enhancing Performance Populating Network Temporary Tables

If you are experiencing performance issue with Refresh Temp Utility views when populating temp tables for network scenarios, add the following entries into the KDD_INSTALL_PARAM table.

These parameters are used in the refreshtemptable job to add HINT in the SQL code.

• PARAM_ID: Unique number. For example, max(PARAM_ID) + 1
• PARAM_NM : Name of the View for which the hint should be added.
• PARAM_VALUE_TX : NULL
• PARAM_VALUE_TYPE_TX : NULL
• PARAM_CAT_CD : RefershTempTable (Hardcoded value)
• ATTR_1_CD: Batch_name (Hardcoded value)
• ATTR_1_VALUE_TX: <batch_name>. For example, DLY
• ATTR_2_CD: Select_Hint (Hardcoded value)
• ATTR_2_VALUE_TX: <hint> that would be used in the query Format /*+ <hint> */ For example, /*+ PARALLEL(8) */
• ATTR_3_CD: Insert_Hint (Hardcoded value)
• ATTR_3_VALUE_TX: <hint> hint to be used in the insert statement Format /*+ <hint> */  For example, /*+ APPEND */