CREATE TABLE dbo.attendm
(
   H_CODE VARCHAR(6) NULL,
   AM_KIND VARCHAR(8) NULL,
   AM_DATE VARCHAR(8) NULL,
   AM_MONEY NUMERIC(7,2) NULL,
   AM_UNITS NUMERIC(7,2) NULL
)

GO

CREATE INDEX LINK1 ON dbo.attendm(H_CODE,AM_KIND)

GO

CREATE INDEX AM_DATE ON dbo.attendm(AM_DATE)

GO

CREATE INDEX AM_KIND ON dbo.attendm(AM_KIND)

GO

CREATE INDEX H_CODE ON dbo.attendm(H_CODE)

END