/*
Phase 10.2.8 — Optional Bed Summary index recommendations
Review with DBA before running on production. Do not run blindly.
*/

-- Speeds current occupied bed calculation:
-- CREATE INDEX IDX_RCP_BED_TRANS_NOW ON RCP_BED_TRANS (ENDDATE, STARTDATE, BEDID);

-- Speeds active bed and unit mapping:
-- CREATE INDEX IDX_STP_BEDS_ROOM_ACTIVE ON STP_BEDS (ROOMID, BEDID, ACTIVE_BED);

-- Speeds room-to-unit mapping:
-- CREATE INDEX IDX_STP_PLACES_PLACE_UNIT ON STP_PLACES (PLACE_ID1, UNIT_ID);
