USE lab09;

#Step 1: Use EXPLAIN on a SELECT statement
EXPLAIN SELECT * FROM student WHERE StudentProgram LIKE 'Computer Science';

#Step 2: Select all rows from student table with the program Computer Science
SELECT * FROM student WHERE StudentProgram LIKE 'Computer Science';

#Step 3: Add index to student table on program name
CREATE INDEX ixStudentProgram ON student(StudentProgram);

#Step 4: Use EXPLAIN on SELECT again and take a screenshot
EXPLAIN SELECT * FROM student WHERE StudentProgram LIKE 'Computer Science';