Summary
Tree-structured indexes are ideal for range-searches, also good for equality searches.
ISAM is a static structure.
- Performance can degrade over time.
B+ tree is a dynamic structure.
- Inserts/deletes leave tree height-balanced; log F N cost.
- High fanout (F) means depth rarely more than 3 or 4.
- Almost always better than maintaining a sorted file.