Suppose that a B+-tree index on (dept_name, building) is available on relation department. What would be the best way to handle the following selection?

Transcribed Image Text:

(building < "Watson") ^ (budget < 55000) ^ (dept_name "Music") (department) = branch(branch_name, branch_city, assets) customer (customer_name, customer_street, customer_city) loan (loan_number, branch_name, amount) borrower (customer_name, loan_number) account (account_number, branch_name, balance) depositor (customer_name, account_number)