What are the limitations of hash-based indexing in a DBMS?

Question

Grade: Education Subject: Ddos
What are the limitations of hash-based indexing in a DBMS?
Asked by:
58 Viewed 58 Answers

Answer (58)

Best Answer
(390)
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.