Progress
Database Administration
Guide and Reference


Base Index (-baseindex)

Operating 
System 
and Syntax 
UNIX 
Windows 
-baseindex n 
Use 
With 
Maximum 
Value 
Minimum 
Value 
Single-user 
Default 
Multi-user 
Default 
DBS

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 4GL code:

FOR EACH _file: 
     DISPLAY _file._file-name. 
     FOR EACH _index WHERE _index._file-recid = RECID(_file): 
           DISPLAY _idx-num _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 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095