IsSparse: Boolean;
The IsSparse property returns whether sparse columns are used to store data
Available values:
True. Sparse columns are used. Sparse columns are regular columns that have an optimized storage for Null values. Sparse columns reduce the space required to store Null values, but more resources are spent to get values that are different from Null. Use sparse columns only if the saved space will be 20-40%
False. Sparse columns are not used.
Executing the example requires that the repository contains a table with the T_ISSPARSE identifier containing a field with the OBT field.
Add links to the Db and Metabase system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Table: ITable;
Field: ITableField;
Begin
MB := MetabaseClass.Active;
// Get table
Table := MB.ItemById("T_ISSPARSE").Edit As ITable;
// Get the OBT field
Field := Table.Fields.FindById("OBT");
Field.IsSparse := True;
(Table As IMetabaseObject).Save;
End Sub UserProc;
After executing the example the OBT field will use sparse columns to store data.
See also: