
CREATE UNIQUE INDEX LD0I1C11 ON LD0P0C11
(
       AEVERKNR,
       INSNR,
       HDATUM,
       HTYP,
       HAGNR
);

CREATE INDEX LD0C0C11 ON LD0P0C11
(
       AEVERKNR,
       HDATUM,
       HTYP,
       HAGNR
);

CREATE INDEX LD0I2C11 ON LD0P0C11
(
       INSNR
) INCLUDE
(AEVERKNR,HDATUM,HTYP,HAGNR,HANDELSE,HTEXT1,HTEXT2,HTEXT3,HTEXT4,TID,UPDDAT,UPDSIGN,MALHANDELSE,TYPDOK,BEVAKNING)
;

CREATE INDEX LD0I3C11 ON LD0P0C11
(
       HTYP,
       HAGNR
) INCLUDE (INSNR);

CREATE INDEX LD0I4C11 ON LD0P0C11
(
       AEVERKNR,
       INSNR
);

CREATE INDEX LD0I5C11 ON LD0P0C11
(
	HAGNR,
	HANDELSE
)
INCLUDE (AEVERKNR,
	INSNR,
	HDATUM,
	HTYP,
	HTEXT1,
	HTEXT2,
	HTEXT3,
	HTEXT4,
	TID,
	UPDDAT,
	UPDSIGN,
	MALHANDELSE,
	TYPDOK,
	BEVAKNING);