Workspaces performance tuning

Workspaces use of database views instead of tables to retrieve data. Retrieval of underlying data might be more time-consuming because of the complexity of SQL statements that are used in workspace view definitions. Data retrieval from a single workspace view is unlikely to have a significant a performance impact. However, joining (inner or outer join) multiple workspace views can decrease performance.

To alleviate potential performance degradations, apply the following interim fixes:
- For DB2 Version 9.5, Fix Pack 8 or later IC71507 ENHANCE QUERY PERFORMANCE THROUGH PUSHDOWN OF ANTI-JOIN(S) THROUGH UNION ALLVIEW(S)
- For DB2 Version 9.7, Fix Pack 5 or later IC76000 ENHANCE QUERY PERFORMANCE THROUGH PUSHDOWN OF ANTI-JOIN(S) THROUGH UNION ALLVIEW(S)
  Note: This interim fix helps to improve performance when you build a Solr index.
  These fixes are only available under DB2 registry variable control.

Run the following command:

db2set DB2_UNION_OPTIMIZATION=ENABLE_NESQ_PD_THRU_UA=YES

Restart the DB2 database manager for the settings to take effect.