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