This video shows a perfect example of how adding indexes to fields that SQL will use for matching records makes all the difference in the world to how fast the computer can complete a job. This video shows how to add indexes and the effect it has. In this case, indexing reduces the number of lookups the computer has to do from about 370 million to 10,000. 10,000 lookups can be done in a second or two. 370 million is going to take 37,000 times longer. Indexing can be complicated to understand, but it doesn't have to be. The basic idea is this. When data is indexed, the computer has a catalog that tells it where each record is. Without an index, the computer has to look at all the records it has to see which of them match what it is looking for. Usually, I avoid analogies but an analogy that has stuck with me is the idea that indexes are like card catalogs for a library and not having indexes is like trying to find books when they are randomly distributed throughout the library and there are no records or signs saying where any of them are. What if you had to find 10 books that way?