CREATE INDEX mdl_backlog_cou_ix ON mdl_backup_log (courseid);
CREATE INDEX mdl_blocinst_blo_ix ON mdl_block_instance (blockid);
CREATE INDEX mdl_blocpinn_blo_ix ON mdl_block_pinned (blockid);
CREATE INDEX mdl_choiansw_opt_ix ON mdl_choice_answers (optionid);
CREATE INDEX mdl_courcate_par_ix ON mdl_course_categories (parent);
CREATE INDEX mdl_datacomm_rec_ix ON mdl_data_comments (recordid);
CREATE INDEX mdl_datacont_rec_ix ON mdl_data_content (recordid);
CREATE INDEX mdl_datacont_fie_ix ON mdl_data_content (fieldid);
CREATE INDEX mdl_datafiel_dat_ix ON mdl_data_fields (dataid);
CREATE INDEX mdl_datarati_rec_ix ON mdl_data_ratings (recordid);
CREATE INDEX mdl_datareco_dat_ix ON mdl_data_records (dataid);
CREATE INDEX mdl_foruqueu_dis_ix ON mdl_forum_queue (discussionid);
CREATE INDEX mdl_lessatte_ans_ix ON mdl_lesson_attempts (answerid);
CREATE INDEX mdl_lessbran_use_ix ON mdl_lesson_branch (userid);
CREATE INDEX mdl_lessbran_les_ix ON mdl_lesson_branch (lessonid);
CREATE INDEX mdl_lessbran_pag_ix ON mdl_lesson_branch (pageid);
CREATE INDEX mdl_lesshighscor_use_ix ON mdl_lesson_high_scores (userid);
CREATE INDEX mdl_lesshighscor_les_ix ON mdl_lesson_high_scores (lessonid);
CREATE INDEX mdl_lesstime_use_ix ON mdl_lesson_timer (userid);
CREATE INDEX mdl_lesstime_les_ix ON mdl_lesson_timer (lessonid);
CREATE INDEX mdl_ques_par_ix ON mdl_question (parent);
CREATE INDEX mdl_quescate_par_ix ON mdl_question_categories (parent);
CREATE INDEX mdl_quesdata_que_ix ON mdl_question_datasets (question);
CREATE INDEX mdl_quesdata_dat_ix ON mdl_question_datasets (datasetdefinition);
CREATE INDEX mdl_quesrqpserv_typ_ix ON mdl_question_rqp_servers (typeid);
CREATE INDEX mdl_quessess_att_ix ON mdl_question_sessions (attemptid);
CREATE INDEX mdl_quessess_que_ix ON mdl_question_sessions (questionid);
CREATE INDEX mdl_quessess_new_ix ON mdl_question_sessions (newest);
CREATE INDEX mdl_quessess_new2_ix ON mdl_question_sessions (newgraded);
CREATE INDEX mdl_quizquesvers_qui_ix ON mdl_quiz_question_versions (quiz);
CREATE INDEX mdl_quizquesvers_old_ix ON mdl_quiz_question_versions (oldquestion);
CREATE INDEX mdl_quizquesvers_new_ix ON mdl_quiz_question_versions (newquestion);
CREATE INDEX mdl_quizquesvers_ori_ix ON mdl_quiz_question_versions (originalquestion);
CREATE INDEX mdl_rolecapa_cap_ix ON mdl_role_capabilities (capability);
CREATE INDEX mdl_wikilock_wik_ix ON mdl_wiki_locks (wikiid);
CREATE INDEX mdl_wikipage_wik_ix ON mdl_wiki_pages (wiki);
CREATE INDEX mdl_workrubr_wor_ix ON mdl_workshop_rubrics (workshopid);
CREATE INDEX mdl_workstoc_wor_ix ON mdl_workshop_stockcomments (workshopid);