alter table ACADEMIC_PERIOD add index (KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_PERIOD);
alter table ACADEMIC_PERIOD add index (KEY_ROOT_DOMAIN_OBJECT_FOR_EXECUTION_YEAR);

alter table CERTIFICATION add index (KEY_EXECUTION_YEAR);

alter table CREDITS add index (KEY_EXECUTION_PERIOD);

alter table ENROLMENT_WRAPPER add index (KEY_ENROLMENT);
