if exists(select * from sys.indexes i where i.[object_id] = OBJECT_ID('EHR.T_EHR_RUS_NPIJ31VJU7', 'U') and i.name = 'IX_NPIJ31VJU7_CodeEHR')
	drop index IX_NPIJ31VJU7_CodeEHR on EHR.T_EHR_RUS_NPIJ31VJU7;
go
CREATE INDEX IX_NPIJ31VJU7_CodeEHR ON EHR.T_EHR_RUS_NPIJ31VJU7 ( CodeEHR ) WITH (MAXDOP = 0, SORT_IN_TEMPDB = ON, DATA_COMPRESSION = PAGE)
go