CREATE TABLE dbo.hist
(
   HI_DATE VARCHAR(8) NULL,
   HI_KIND VARCHAR(4) NULL
)

GO

CREATE INDEX DATEKIND ON dbo.hist(HI_DATE,HI_KIND)

GO

CREATE INDEX HI_DATE ON dbo.hist(HI_DATE)

END