Kbase P100622: Why the FIRST_ROWS hint is sent by Oracle DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2008 |
|
Status: Verified
GOAL:
Why the FIRST_ROWS hint is sent by Oracle DataServer?
GOAL:
Under what circumstances the FIRST_ROWS optimizer mode hint is sent by Oracle DataServer
FACT(s) (Environment):
Oracle DataServer
OpenEdge 10.x
All Supported Operating Systems
FIX:
Oracle DataServer provides the FIRST_ROWS optimizer hint when it knows it only wants one row back into its result set. There are various conditions that will cause this like FOR FIRST, dynamic FIND, and most commonly, when RECID is used to select a matching record. There is no switch to turn it off.