How ABL chooses and brackets indexes to satisfy queries

Knowing the importance of creating indexes to support common data access patterns is a big step toward efficient design. However, to make your query code and indexes work together effectively, you must understand how ABL chooses indexes to satisfy a particular query.

Efficient query coding is outside the scope of this book, but its relevance to index design and creation cannot be overstated. Therefore, this section briefly explains how ABL chooses the most efficient indexes based on the ABL query. Then, you will learn how ABL brackets an index, when possible, to minimize the number of fetched records.