Addindex

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

See Also

• Indexes
• Remove Index