Kbase P112912: Interpretation of data within the VST _IndexStat.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Interpretation of data within the VST _IndexStat.
GOAL:
Interpretation of data from Fathom Index Statistics Detail Report
FIX:
Within the VST _indexStat table, the columns _IndexStat-read _IndexStat-create _IndexStat-delete are giving the number of time an index is accessed in memory for a Read a Create a Delete. An record update with data modification of a column part of a certain index results in one Delete and one Create for that index.
The column _IndexStat-split is giving the number of occurrences a new block was added to the index tree, resulting from an Index Block Split; this will occur on a record add/update.
The column _IndexStat-split is giving the number of occurrences a new block was added to the index tree, resulting from an Index Block Split; this will occur on a record add/update. The column _IndexStat-blockdelete is giving the number of occurrences a block was deleted from the index tree, resulting from a record delete or from an index compaction (using the command "proutil <db> -C idxcompact").
Running the following program against a copy of sports database demonstrates data within_IndexStat. table for index customer.name when modifying the field customer.name.
FOR EACH _indexstat WHERE _indexstat-id > 0:
FIND _index WHERE _idx-num = _indexstat-id NO-ERROR.
IF AVAILABLE _index THEN DO:
FIND _file where RECID(_file)= _index._file-recid.
IF _file._file-name = "customer" THEN DO :
IF _index._index-name = "Name" OR _index._index-name = "Cust-Num" THEN
DISPLAY _index._index-name _indexstat-create _indexstat-delete _indexstat-read.
END.
RELEASE _indexstat.
END.
END.
RUN modifCust.
FOR EACH _indexstat WHERE _indexstat-id > 0:
FIND _index WHERE _idx-num = _indexstat-id NO-ERROR.
IF AVAILABLE _index THEN DO:
FIND _file where RECID(_file)= _index._file-recid.
IF _file._file-name = "customer" THEN DO :
IF _index._index-name = "Name" OR _index._index-name = "Cust-Num" THEN
DISPLAY _index._index-name _indexstat-create _indexstat-delete _indexstat-read.
END.
RELEASE _indexstat.
END.
END.
PROCEDURE modifCust:
FIND FIRST customer.
UPDATE name = name + "updated".
END PROCEDURE.