Base Index (-baseindex)

Use Base Index (-baseindex) with IndexRange Size (-indexrangesize) to specify the range of indexes for which you want to collect statistics.

Operating system and syntax	UNIX / Windows	-baseindex n
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
Database Server	32765	-32765	—	—

The starting index number in the range of indexes for which you want to track access 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:
  DISPLAY _file._file-name.
  FOR EACH _index WHERE _index._file-recid = RECID(_file):
    DISPLAY _index._idx-num _index._index-name.
  END.
END.

Running the preceding code results in the following output:

File-Name
filename

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

For more information on virtual system tables, see OpenEdge Data Management: Database Administration.