TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

510 Chapter11
B-Tree Indices
Quick Start for Using B-Tree Indices
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.