Addindex: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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 | |||
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
