CREATE INDEX IX_T_AMBULANCE_CARD_RECORD_AmbulanceCard ON AKUZ.T_AMBULANCE_CARD_RECORD ( AmbulanceCard, PostingDate ) INCLUDE ( AmbulanceEvent, Movement) WITH (FILLFACTOR=90, SORT_IN_TEMPDB= ON);
GO

CREATE INDEX IX_T_AMBULANCE_CARD_RECORD_Movement ON AKUZ.T_AMBULANCE_CARD_RECORD(Movement, PostingDate) INCLUDE(AmbulanceCard, AmbulanceEvent) WITH (FILLFACTOR=95);
go

CREATE INDEX IX_AMBULANCE_CARD_RECORD_AmbulanceEvent ON AKUZ.T_AMBULANCE_CARD_RECORD ( AmbulanceEvent, PostingDate ) INCLUDE ( AmbulanceCard, Movement) WITH (FILLFACTOR=90, SORT_IN_TEMPDB= ON);
go

CREATE INDEX IX_T_AMBULANCE_CARD_RECORD_PostingDate_Includes ON AKUZ.T_AMBULANCE_CARD_RECORD (PostingDate)  INCLUDE (AmbulanceCard, AmbulanceEvent, PatientBase) WITH (FILLFACTOR=90, SORT_IN_TEMPDB= ON);
GO

CREATE INDEX IX_T_MEDICAL_RECORD_TYPE_ ON AKUZ.T_MEDICAL_RECORD ( type_ ) INCLUDE ( Post, RecordDate, RecordTime, Users) WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON)
go
CREATE INDEX IX_T_MEDICAL_RECORD_DATE2 ON AKUZ.T_MEDICAL_RECORD ( RecordDate ) INCLUDE ( Post, RecordTime, type_, Users) WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON)
go
CREATE INDEX IX_T_MEDICAL_RECORD_POST ON AKUZ.T_MEDICAL_RECORD ( Post, type_ ) INCLUDE ( RecordDate, RecordTime, Users) WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON)
go