Improves performance
It needs to be specified at table creation
If less than 100 records, you should not need it.
It works the same way as in an index of books on a library: instead of looking at each book until we find the one we are looking for, it organizes the books in some sort of order so when we request for one we don’t have to go through all of them.