Select * from Student join Faculty on Student.Name_Last = Faculty.Name_Last

With the query above :

Performance of the query with the index that existed (primary keys only)

Performance of the query with a multiple column index on ID and Name_Last for both the Student and Faculty Table

Performance of the query with an index only on Name_Last in the Student and Faculty tables