Workorder and PM indexes that may help performance

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

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

One thought on “Workorder and PM indexes that may help performance

Leave a Reply