Addindex: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 9: | Line 9: | ||
Expression can be comma separated field values as: "Name,ContactId" etc. | Expression can be comma separated field values as: "Name,ContactId" etc. | ||
<nowiki>*</nowiki>functional index means it uses the BTree approach | |||
See Also | |||
* [[Indexes]] | |||
* [[Removeindex|Remove Index]] | |||
Latest revision as of 07:30, 20 August 2026
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
