Slow Lombardi Process Designer

During development time the Process Designer makes many queries to LSW_ENV_VAR.
This table is not large, however, one of the queries used by PD has a sub-query against LSW_PO_VERSIONS

This article (http://www-01.ibm.com/support/docview.wss?uid=swg21610258
) describes adding a few indexes to LSW_PO_VERSIONS and it worked a treat.

This other article (http://www-01.ibm.com/support/docview.wss?uid=swg1IC82730) was a little more involved and we didn't try it.. but worth a mention.