Using Index in JBASE

What is the version of Jbase which support INDEX?

Currently we are using T24 R8.005 with jBase version 5.0.23 in IBM UNIX 5.3.

If the index support in jbase 5.0.23, please sent me the procedure to create index in jBase.

Thanks and best regards,

Following are indexing commands in jabase 5.10 use them if these help

Creation of Index
Jsh-create-extindex –v FXXX.APPLICATION <<FIELD NAME AS IN STANDARD.SELECTION>>


Deletion of index
DELETE-EXTINDEX –v FILE.NAME INDEX.NAME


Moreover please take care of the following point while using index


The frequently queried fields should be indexed properly to improve the performance in SELECT but it may slowdown the update.

Maximum 4 indexes can be created for a table. (2- 4 MAX)

For heavily updated but lightly queried tables fewer indexes the better (2) otherwise update will slow down so transaction performance will be reduced.

For lightly updated tables but heavily queried tables, i.e. Customers, Category,? Etc then additional indexes also make sense....(4 max)