Name some disadvantages of a hash index

Technology CommunityCategory: SQLName some disadvantages of a hash index
VietMX Staff asked 3 years ago

Hash tables are not sorted data structures, and there are many types of queries which hash indexes can not even help with. For instance, suppose you want to find out all of the employees who are less than 40 years old. How could you do that with a hash table index? Well, it’s not possible because a hash table is only good for looking up key value pairs – which means queries that check just for equality.