Db

Think of this as the book's index at the back of a novel. Without an index, a DB must read every row to find a match (a "full table scan"). With an index, it locates the data instantly. Poor indexing is the number one cause of slow applications.