Consider the query: select * from r, s where upper(r.A) = upper(s.A) where upper is a function that returns its
Consider the query:
from r, s
where upper(r.A) = upper(s.A)
where “upper” is a function that returns its input argument with all lowercase letters replaced by the corresponding uppercase letters.
a. Find out what plan is generated for this query on the database system you use.
b. Some database systems would use a (block) nested-loop join for this query, which can be very inefficient. Briefly explain how hash-join or merge-join can be used for this query
This problem has been solved!
Step by Step Answer: