antatiana
asked on
what's advantage has indexed file over the hashed files and what's advantages has hashed files over indexed?
what's advantage has indexed file over the hashed files and what's advantages has hashed files over indexed?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://markp3rry.blogspot.com/2007/12/indexed-vs-hashed-files.html
"...indexes are best used when there are no limits on storage space - a large database will always have space available for indexes because of the extra efficiency in searching. Also , I think that indexes are less prone to errors than hashing files - no chance of collision or clustering . However hashing isn ' t as wasteful in terms of needing extra resources to implement, and is quicker when done properly because there aren ' t two files to maintain."