I received a log report from our Server Admin mentioning that there were tables in our Moodle which has been queried without indexes (as shown below). Kindly advise what needs to be done and suggest whether this is a normal log and does not affect the overall performance of our portal. Thank you.
Table has been queried without using indexes: moodle.enrolment with a total of 1169567792 IO operations (1169495407 Read / 72385 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_grade_grades with a total of 4533824 IO operations (4533824 Read / 0 Write / 0 Delete)Table has been queried without using indexes: moodle.mdl_grade_categories with a total of 121618 IO operations (121618 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_grade_items with a total of 227429 IO operations (227429 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_user with a total of 356860 IO operations (356860 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_course with a total of 32149 IO operations (32149 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_activequiz with a total of 132 IO operations (132 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_activequiz_attempts with a total of 1500 IO operations (1500 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_activequiz_grades with a total of 912 IO operations (912 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_activequiz_groupattendance with a total of 3 IO operations (3 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_activequiz_questions with a total of 468 IO operations (468 Read / 0 Write / 0 Delete)
Table has been queried without using indexes: moodle.mdl_activequiz_sessions with a total of 174 IO operations (174 Read / 0 Write / 0 Delete)