-- #New 29.11.2013

-- #Doc delete indizes
-- DROP INDEX INFODBA.JobMgr$$_01_PITEM_ID_PUID;
-- DROP INDEX INFODBA.JobMgr$$_02_PITEM_REVID;

-- #Doc create indizes
create index INFODBA.JobMgr$$_01_PITEM_ID_PUID on INFODBA.PITEM("PITEM_ID","PUID") tablespace "IDATA" online parallel 2;
create index INFODBA.JobMgr$$_02_PITEM_REVID on INFODBA.PITEMREVISION("PITEM_REVISION_ID") tablespace "IDATA" online parallel 2;
