NexusDB

In code, creating and linking the index object structure together works like this: First, add a new IndexDescriptor object to the dictionary's array of IndexDescriptors. The AddIndex call does this for you. Notice that you also specify in this call wether you want a regular field-based index or a SAI index, by passing in the type of the KeyDescriptor object you want. Note that the KeyDescriptor object is also created for you inside this call.

Then (assuming it's a field-based index), using the newly constructed object, we add one or more fields to the index:

Member and thus Index Field Options can now be changed from the defaults, if needed:

As mentioned above, using the data dictionary gives you much more flexibility over index creation.    If you don't need the fine control that the data dictionary gives you, you can just use TIndexDefs, TFieldDefs and the CreateTable method of TDataset instead. See the Borland VCL help for description and examples.