Topic complex |
Table functions |
Function |
regenall() |
Short |
Regenerates all indices of a table |
Syntax |
REGENALL(db : INTEGER) : INTEGER |
Parameter |
db : table handle from OPENDB |
Return |
error code,
0 = execution successful |
See also: |
|
Description |
The indices of a table are always set dynamically by the tdbengine. But very often deleting records can affect an index to use more space than it requires actually. In such a case the regeneration of the indices can influence the storage occupancy and the manner of access oportunely.
|