if exists(select * from sys.indexes i where i.[object_id] = OBJECT_ID('PHARM.S_DLO_DoseView', 'U') and i.name = 'IX_S_DLO_DoseView_Value')
	drop index IX_S_DLO_DoseView_Value on [PHARM].S_DLO_DoseView;
go
CREATE INDEX IX_S_DLO_DoseView_Value ON [PHARM].[S_DLO_DoseView] ( [Value] ) WITH (FILLFACTOR = 95, SORT_IN_TEMPDB = ON)
go