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. points SELECT a b c f FROM T WHERE a AND b AND d AND e ; 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
