Kbase P19818: What is the difference of using FOR FIRST versus FIND FIRST
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
What is the difference of using FOR FIRST versus FIND FIRST
GOAL:
FOR FIRST vs. FIND FIRST
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
FIND FIRST:
- Finds the first record in the table that meets the characteristics you might have specified with record. If the buffer named in the record was preselect in a DO or REPEAT statement, FIND locates the first record in that preselect subset of records.
- uses only single index: See Progress Database Design Guide (chapters 4 and 5)
FOR FIRST:
- Uses the criteria in the record-phrase to find the first record in the table that meets that criteria. Progress finds the first record before any sorting.
- You can add a fields list to reduce network traffic.
- You can take advantage of multiple indexes: See Progress Database Design Guide (chapters 4 and 5)
- The query maps better in to SQL when running across a DataServer.