0 votes 0 votes The database can be configured to do ordered indexing on Ap or hashing on Ap. Which of the following statements is TRUE?(A) Ordered indexing will always outperform hashing for both queries(B) Hashing will always outperform ordered indexing for both queries(C) Hashing will outperform ordered indexing on Q1, but not on Q2(D) Hashing will outperform ordered indexing on Q2, but not on Q1. Databases databases + – radha gogia asked Aug 15, 2015 radha gogia 672 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes $A_p = C$ -Hashing would mean constant time to get the tuple from the index. $C_1 \leq A_p \leq C_2$- We need to scan a range of values in index to determined the matching tuples. So, C should be the answer. Arjun answered Aug 15, 2015 Arjun comment Share Follow See 1 comment See all 1 1 comment reply radha gogia commented Aug 15, 2015 reply Follow Share Sir can u plz explain why hashing can't be performed in option D ? 1 votes 1 votes Please log in or register to add a comment.