Question: Given a table T with six columns ( a , b , c , d , e , f ) , you created two indexes

Given a table T with six columns (a, b, c, d, e, f), you created two indexes on this table. The first index is a hash index on the search key . The second index is a B+ tree index on key . For the following SQL query, select the best answer. (2 points) SELECT a, b, c, f FROM T WHERE a =20 AND b <20 AND d >20 AND e <20; A. There is an index match on the hash index only B. There is an index match on the B+ tree index only C. There is an index match on both indexes D. There is no index match

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!