You might be thinking that doing a full table scan sounds inefficient for something so
simple – shouldn’t software be smarter? It’s almost like looking through the entire
table with the human eye – very slow and not at all sleek. But, as you probably
guessed by the title of this article, this is where indexes can help a great deal. The
whole point of having an index is to speed up search queries by
essentially cutting down the number of records/rows in a table that need
to be examined