Consider the following two relations for Millennium College
STUDENT(StudentID, StudentName,CampusAddress, GPA)
REGISTRATION(StudentID, CourseID, Grade)
Following is a typical query against these Relation:
SELECT Student_T.StudentID,StudentName,
CourseID, Grade
FROM Sudent_T, Registration_T
WHERE Student_T.StudentID =
Registration_T.StudentID
AND GPA> 3.0
ORDER BY StudentName;
Required:
On what attributes should indexes be defined to speed up this Query? PLease give reasons for each selected