Base Index (-baseindex)

Database Administration

Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : Base Index (-baseindex)

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

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