First page Back Continue Last page Image

So an Index is all about Speed

The reason I create an Index is to speed up or optimize our queries

An index is a intermediate table created based on a specified Field (or Fields), intended to make queries for that field much faster

Building the Index takes time so you have to weigh the benefits and costs to determine if it is worth the effort