[prev] 21 [next]

EXPLAIN Examples

Database

people(id, family, given, title, name, ..., birthday)
courses(id, subject, semester, homepage) 
course_enrolments(student, course, mark, grade, ...) 
subjects(id, code, name, longname, uoc, offeredby, ...)
...

where

       table_name          | n_records 
---------------------------+-----------
 people                    |    150963
 courses                   |     34955
 course_enrolments         |   1812317
 subjects                  |     33377
...