Database performance often copyrights on the effective use of lookups. Think of an directory for a book ; instead of reading every page , you can easily find the record you need . Search aids are specialized https://index392314.pointblog.net/understanding-indexes-in-databases-95478888