Kbase P135778: Is it possible to retrieve runtime index information on dynamic find methods?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/01/2009 |
|
Status: Unverified
GOAL:
Is it possible to retrieve runtime index information on dynamic find methods?
GOAL:
How to retrieve index information using <buffer-handle>:FIND-FIRST() or <buffer-handle>:FIND-LAST() or <buffer-handle>:FIND-UNIQUE() or <buffer-handle>:FIND-CURRENT() ?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
QRYINFO logging won?t give us this information. It will work only on queries, not buffer handles. At the time QRYINFO was implemented, it was a deliberate decision not to log information for standalone FIND statements/methods.
Using VSTs might be a solution for a single-user database. Compare the index reads before executing the FIND method to the index block reads afterwards. The indices with increased reads would be the ones used. But this statistic is not per-user, so on a multi-user database this might not be accurate.