USE repositorio_ib;

ALTER TABLE monographs ADD INDEX idx_monographs_title (title);
ALTER TABLE monographs ADD INDEX idx_monographs_subject_area (subject_area);
ALTER TABLE monographs ADD INDEX idx_monographs_session_year (session_year);
ALTER TABLE monographs ADD INDEX idx_monographs_status (status);
ALTER TABLE monographs ADD INDEX idx_monographs_student_id (student_id);
ALTER TABLE monographs ADD INDEX idx_monographs_advisor_id (advisor_id);