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. TheHow do database indexes work? 1/17/2557 BE, 10:35 AM
http://www.programmerinterview.com/index.php/database-sql/what-is-an-index/ Page 2 of 6
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.