Скрипт 03_indices

-- execute procedure mds_meta_upd_index('index_name', 'table', 'field_or_expression');

execute procedure mds_meta_upd_index('idx_mds_nterm_smo_territory', 'mds_nterm_smo', 'territory_code');

execute procedure mds_meta_upd_index('idx_mds_nterm_mo_head_mo', 'mds_nterm_mo', 'head_mo');
execute procedure mds_meta_upd_index('idx_mds_nterm_mo_part_of', 'mds_nterm_mo', 'part_of');

execute procedure mds_meta_upd_index('idx_mds_nterm_jpersons_rir_guid', 'jpersons', 'rir_guid');
execute procedure mds_meta_upd_index('idx_mds_nterm_cashref_rir_guid', 'cashref', 'rir_guid');

execute procedure mds_meta_upd_index('idx_mds_dicinfodet_second_pair', 'dicinfodet', 'secondrefid,seconddicid');
execute procedure mds_meta_upd_index('idx_mds_sync_reference_refcode', 'sync_reference', 'refcode');

execute procedure mds_meta_upd_index('idx_mds_nterm_mo_code', 'mds_nterm_mo', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_smo_code', 'mds_nterm_smo', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_region_code', 'mds_nterm_region', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_aid_form_code', 'mds_nterm_aid_form', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_aid_place_code', 'mds_nterm_aid_place', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_aid_type_code', 'mds_nterm_aid_type', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_canc_reason_code', 'mds_nterm_cancellation_reason', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_canc_source_code', 'mds_nterm_cancellation_source', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_diag_type_code', 'mds_nterm_diagnosis_type', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_doct_posit_code', 'mds_nterm_doctor_position', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_doct_spec_code', 'mds_nterm_doctor_speciality', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_docum_type_code', 'mds_nterm_document_type', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_prof_med_ser_code', 'mds_nterm_profile_med_service', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_refer_status_code', 'mds_nterm_referral_status', 'code');
execute procedure mds_meta_upd_index('idx_mds_nterm_refer_type_code', 'mds_nterm_referral_type', 'code');

sql