||Regenerates the index of a table
||REGENIND(db : INTEGER; indexno : INTEGER) : INTEGER
||db : table handle from OPENDB
indexno : number of the to generating index
0 = index regenerated successfully
The indices of a table are always set dynamically by the tdbengine. But very often deleting of records can affect an index to use more space than it requires actually. In such a cause the regeneration of the indices can influence the storage occupancy and the manner of access oportunely.
An error can occur if the table has not been opened with the right of indexing.