Workspaces performance tuning

Workspaces use database views instead of tables to retrieve data. Retrieval of underlying data might be more time-consuming because of the complexity of SQL statements 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.

1. Run the following command:

   db2set DB2_UNION_OPTIMIZATION=ENABLE_NESQ_PD_THRU_UA=YES

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