Addindex: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
Syntax : addindex "<ISLAND NAME>" "<EXPRESSION>" <ENTER> | Syntax : addindex ["<INDEX NAME>"] "<ISLAND NAME>" "<EXPRESSION>" <ENTER> | ||
Description : To add a new index based on an island and expression. | 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 | EG | ||
>addindex "contacts" "Name" | >addindex "idxcontactnames" "contacts" "Name" | ||
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 | |||
Latest revision as of 12:35, 24 April 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
