CREATE  UNIQUE INDEX PCCC0MOT ON PCCP0MOT
(
	MEDDID,
	MOTTID,
	MOTTAGDAT,
	MOTTAGTID
);


CREATE INDEX PCCI1MOT ON PCCP0MOT
(
	MOTTID,
	MOTTBORTTAG
);

CREATE NONCLUSTERED INDEX PCCI2MOT
ON PCCP0MOT (MOTTID,MOTTBORTTAG,MOTTAGDAT)
INCLUDE (MAPPID)
;