USE [STATION]
GO

CREATE NONCLUSTERED INDEX [by_RecordStatus] ON [dbo].[tbRoomTransferRequest]
(
	[RecordStatus] ASC
)
GO

USE [STATION]
GO

CREATE nonCLUSTERED INDEX [by_IDNum] ON [dbo].[tbNurseVitalSigns]
(
	[IDnum] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_IDNum] ON [dbo].[tbNurseProfile]
(
	[IDNum] ASC
)
GO

USE [INVENTORY]
GO

CREATE NONCLUSTERED INDEX [by_Consumption_Date] ON [dbo].[tbInvStockCard]
(
	[Consumption_Date] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_LocationID_UserID] ON [dbo].[tbInvUserLocation]
(
	[LocationID] ASC,
	[UserID] ASC
)
GO


USE [LABORATORY]
GO

CREATE NONCLUSTERED INDEX [by_IDNum] ON [dbo].[tbLABLogBook]
(
	[IDNum] ASC
)
GO

USE [PATIENT_DATA]
GO

CREATE NONCLUSTERED INDEX [by_IDNum] ON [dbo].[tbpatientHistory]
(
	[IDNum] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_IDNum] ON [dbo].[tbpatientInformant]
(
	[IDNum] ASC
)
GO

USE [LABORATORY]
GO
CREATE NONCLUSTERED INDEX [By_InstrumendID_ExamName_SampleNum] ON [dbo].[tbLabInstrumentDLHemaResult] 
(
	[InstrumentID] ASC,
	[ExamName] ASC,
	[SampleNum] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO