Addindex
From Data Islands
Syntax : addindex ["<INDEX NAME>"] "<ISLAND NAME>" "<EXPRESSION>" <ENTER>
Description : To add a new index based on an island and expression. Please note, the first parameter is optional, so if user give the index_name then the index will get created with PostgreSQL Trigram approach otherwise it will be functional index.
EG
>addindex "idxcontactnames" "contacts" "Name"
Expression can be comma separated field values as: "Name,ContactId" etc.
*functional index means it uses the BTree approach
