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
  

--[tbLABLogBook]

declare @qry nvarchar(max);
select @qry =  (SELECT  'DROP INDEX ' + ix.name + ' ON ' + OBJECT_NAME(ID) + '; ' FROM  sysindexes ix WHERE   ix.Name IS NOT null and ix.Name like '%tbLabLogbook%' for xml path(''));
--exec sp_executesql @qry



CREATE CLUSTERED INDEX [by_RequestNum] ON [Laboratory].[dbo].[tbLABLogBook]
(
	[RequestNum] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_HospNum_IDNum_RefNum_RequestNum] ON  [Laboratory].[dbo].[tbLABLogBook]
(
	[HospNum] ASC,
	[IDNum] ASC,
	[RefNum] ASC,
	[RequestNum] ASC
)
GO

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

CREATE NONCLUSTERED INDEX [by_RefNum] ON  [Laboratory].[dbo].[tbLABLogBook]
(
	[RefNum] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_LabSectionID_TransDate] ON  [Laboratory].[dbo].[tbLABLogBook]
(
	[LabSectionID] ASC,
    [TransDate] ASC,
	[RefNum] ASC,
	[FormType] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_LabSectionID_ResultDate] ON  [Laboratory].[dbo].[tbLABLogBook]
(
	[LabSectionID] ASC,
    [ResultDate] ASC
)
GO

CREATE NONCLUSTERED INDEX [by_VerifyDate] ON [Laboratory].[dbo].[tbLABLogBook]
(
	[VerifyDate] ASC
) 
GO 

CREATE NONCLUSTERED INDEX [by_accessionnum] ON [Laboratory].[dbo].[tbLABLogBook]
(
	[AccessionNum] 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


USE [Doctors]
GO

CREATE NONCLUSTERED INDEX [by_HospNum_IDNum_DoctorID] ON [dbo].[DOC_Orders]
(
	[HospNum] ASC,
	[IdNum] ASC,
	[DoctorID] ASC,
	[SelectedDocID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

USE [PATIENT_DATA]
GO
 
CREATE NONCLUSTERED INDEX [by_IDNum_AreaCat_AreaSubCat_Description_Code] ON [dbo].[tbPatientConditions]
(
	[IDNum] ASC,
	[AreaCat] ASC,
	[AreaSubCat] ASC,
	[Description] ASC,
	[Code] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

CREATE NONCLUSTERED INDEX [By_AssignedTo] ON  Station..tbNurseProfile
GO

CREATE NONCLUSTERED INDEX [By_Name] ON Build_File..tbcoAbbreviation
GO

CREATE CLUSTERED INDEX [by_IDNum_TransDate] ON Station..tbNurseVitalSigns
GO

CREATE NONCLUSTERED INDEX [by_IDNum_TransDate] ON Station..tbStationLogs 
GO