Quick Start for Using B-Tree Indices [ TurboIMAGE/XL Database Management System Reference Manual ] MPE/iX 5.5 Documentation
TurboIMAGE/XL Database Management System Reference Manual
Quick Start for Using B-Tree Indices
If you are interested in generic trailing-@ searches only and want to get
started quickly without making any application changes, you may use the
following steps.
1. Identify the masters with ASCII key item and can benefit from
B-Tree indices.
2. Create B-Tree indices using either of these methods:
a. Use the INDEXED option of DBSCHEMA for new databases.
b. Use the ADDINDEX command of DBUTIL for existing databases.
3. Set the BTREEMODE1 option ON using DBUTIL as follows:
:Run DBUTIL.PUB.SYS
>SET database name [/maintword] BTREEMODE1=ON
If your database is new, you will need to add data. Then you are ready
to perform B-Tree index searches. You can include the wildcard character
in your DBFIND argument and observe the results.
MPE/iX 5.5 Documentation