mv_stat_lvl_2_imt_indices

CREATE UNIQUE INDEX IF NOT EXISTS index_mv_stat_lvl_2_imt_indices_on_id ON public.mv_stat_lvl_2_imt_indices USING btree (id)
CREATE INDEX IF NOT EXISTS idx_mv_stat_imt_indices_employee ON public.mv_stat_lvl_2_imt_indices USING btree (employee_id)
CREATE INDEX IF NOT EXISTS idx_mv_stat_imt_indices_patient ON public.mv_stat_lvl_2_imt_indices USING btree (patient_id)
CREATE INDEX IF NOT EXISTS idx_k4_mv_stat_lvl_2_imt_indices_asserted_date_patient_id ON public.mv_stat_lvl_2_imt_indices USING btree (asserted_date, patient_id)
CREATE INDEX IF NOT EXISTS idx_k4_mv_stat_lvl_2_imt_indices_legal_entity_id_employee_id_as ON public.mv_stat_lvl_2_imt_indices USING btree (legal_entity_id, employee_id, asserted_date) INCLUDE (patient_id) WHERE (imt_index > (25)::double precision)