Kbase P4206: What is the use of USE-INDEX function with the DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/04/2003 |
|
Solution ID: P4206
GOAL:
What is the use of USE-INDEX function with the DataServer?
FIX:
It will dictate the use of the ORDER BY clause generated for SQL Statement, thus ensuring records to be returned in a predictable order. However, it will NOT ensure the use of the index specified as with Progress Database.