-- Phase 8 - Beds & Occupancy performance recommendations
-- Review execution plans before applying on production.
-- These indexes are intentionally commented. Enable only after DBA approval.

-- CREATE INDEX IDX_RCP_BED_TRANS_BED_DATE ON RCP_BED_TRANS (BEDID, STARTDATE, ENDDATE);
-- CREATE INDEX IDX_RCP_BED_TRANS_START ON RCP_BED_TRANS (STARTDATE);
-- CREATE INDEX IDX_RCP_BED_TRANS_OPEN ON RCP_BED_TRANS (ENDDATE, COMP_PAT_FLAG, BEDID);
-- CREATE INDEX IDX_STP_BEDS_BED_ROOM ON STP_BEDS (BEDID, ROOMID, ACTIVE_BED);
-- CREATE INDEX IDX_STP_PLACES_PLACE_UNIT ON STP_PLACES (PLACE_ID1, UNIT_ID);
-- CREATE INDEX IDX_STP_HRC_UNIT ON STP_HRC (UNIT_ID);
