Mid SQL Faster Search: Indexes allow the database to locate rows much faster than a full? table scan.