Indexes prevent the database engine from having to scan ever

Indexes prevent the database engine from having to scan every record in the database. True False

Solution

Answer: True

Indexes prevent the database engine from having to scan every record in the database.

Indexes provides the improvement of query performance by providing the database engine with fast way of locating a particular record based on the a column or columns provided in where condition.