The following indexes should be used in a test or development environment before using in production and may help to increase performance with regard to work orders and PMs:

CREATE INDEX MAXIMO.MULTIASSETLOCCI_SNLX1 ON MAXIMO.MULTIASSETLOCCI
(SITEID, ASSETNUM)

CREATE INDEX MAXIMO.MULTIASSETLOCCI_SNLX2 ON MAXIMO.MULTIASSETLOCCI
(WORKSITEID, RECORDCLASS, RECORDKEY)

CREATE INDEX MAXIMO.MULTIASSETLOCCI_SNLX3 ON MAXIMO.MULTIASSETLOCCI
(WORKSITEID);

CREATE INDEX WORKORDER_WOGROUP ON WORKORDER(WOGROUP);

CREATE INDEX WORKLOG_TEST ON WORKLOG(RECORDKEY,CLASS,SITEID);

Provided By IBM Support