example-of-a-query-that-can-be-evaluated-by-using-the-index-alone-computer-science-help
Consider a table student(student_id, student_name, major, credits_passed) with a B-tree index on attributes (major, credits_passed). Give an example of a query that can be evaluated by using the index alone, without referring to the rows in the table. (Query plans that use the index, without accessing the actual table, are called index-only plans).