|
It is possible to define Table index. Those index can be used for:
- Define primary key.
- Define Constraint.
- Improve search performance
Index property are:
Name Index Name
Label Label (language based) to show when user reference this index.
Columns Column define the index.Syntax:
<Column1>; ... ;<ColumnN>
where <ColumnX> is a column of table. It is possible to use just collumn with DataType set to NUMERIC, DOUBLE, CHAR, DATETIME o BOOLEAN.
Unique If index is unique. When set to true it do not admit duplicate values for column.
|
|
Last Updated on Thursday, 01 October 2009 14:46 |