Release 10.1A: OpenEdge Data Management:
Database Administration

> ## 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095