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 beneļ¬t 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.