Question
What are the limitations of hash-based indexing in a DBMS?
Asked by: USER8925
58 Viewed
58 Answers
Answer (58)
Hash-based indexing has limitations. It's not suitable for range queries because the hash value doesn't provide information about the order of the data. It can also be less efficient for data with a large number of unique keys, potentially leading to a larger hash table size. Maintaining the hash table structure can also be resource-intensive, especially during insertions and deletions.