Progress
Database Design
Guide
How Progress 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 Progress 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 Progress chooses the most efficient index or indexes based on the 4GL query. Then, you will learn how Progress brackets an index, when possible, to minimize the number of fetched records.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |