-baseindex n

n

The starting index number in the range of indexes for which you want to track access statistics.

Use Base Index (-baseindex) with Index Range Size (-indexrangesize) to specify the range of indexes for which you want to collect statistics. Access to the statistics is handled through the Virtual System Tables (VSTs). Index statistics are stored in the _IndexStat VST. To obtain index numbers, use the following ABL code:

FOR EACH _file NO-LOCK:
  DISPLAY _file._file-name.
  FOR EACH _index WHERE _index._file-recid = RECID(_file) NO-LOCK:
    DISPLAY _index._idx-num _index._index-name.
  END.
END.

This results in the following output:

File-Name
filename

_idx-num Index-Name
     n1   index name1
     n2   index name2
     n3   index name3

To change this parameter while the database is running, use PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.