I need to efficiently locate all records in my DBMS that have zip code 75019. Is it good idea to use B+ tree index
or Hash index or neither?
B+ tree is balanced lookup tree, which was designed for disks and storage support. It can store all the records in the leaf... View the full answer