CREATE INDEX LD0I1H ON LD0P0H
(
       PNR
);

CREATE INDEX LD0I2H ON LD0P0H
(
       INSNR
);

CREATE INDEX LD0I4H ON LD0P0H
(
       BESLUTNR
);

CREATE INDEX LD0I5H ON LD0P0H
(
       ORGENHNR
)
INCLUDE (AKTUALNR,INSNR,ORGID,AEVERKNR,BESLUTNR,AKTUAL,AKTUALTYP,ADATUM,AVEM,AORSAK,HAND,RENSAD,DIARIENR,AKTNR,SPOTCHECK)
;


CREATE INDEX LD0I7H ON LD0P0H
(
       MODER
);

CREATE INDEX LD0I8H ON LD0P0H
(
       FAMRATTNR,
       AEVERKNR,
       INSNR,
       ORGID,
       AKTUAL,
       ORGENHNR,
       ADATUM,
       MODER
);

CREATE INDEX LD0I9H ON LD0P0H
(
ADATUM
) INCLUDE(AKTUALNR, INSNR, AEVERKNR,AKTUAL);

CREATE INDEX LD0IAH
ON LD0P0H (AEVERKNR,AKTUALNR)
INCLUDE(INSNR, ORGID, AKTUAL, ORGENHNR)
;

CREATE INDEX LD0IBH ON LD0P0H (
BESLUTNR, 
PROCDATUM,
AKTUALTYP, 
ADATUM)
;

CREATE INDEX LD0ICH ON LD0P0H (
AKTUALTYP)
;

CREATE INDEX LD0IDH
ON LD0P0H (BESLUTNR,AKTNR)
INCLUDE (AKTUALNR,INSNR,ORGID,AEVERKNR,AKTUAL,AKTUALTYP,ADATUM,ORGENHNR,HAND,UPDDAT,UPDSIGN,HAND2,RENSAD,DIARIENR,REGTID,WORKFLOW,SPOTCHECK)
;

CREATE INDEX LD0IEH ON LD0P0H (AKTNR, ADATUM DESC)
;