Hi, I created the array index using SUFFIXES but the size of it is over 160MiB, too big. CREATE INDEX idx_name_suffixes ON `sample` ( DISTINCT ARRAY v FOR v IN SUFFIXES(LOWER(name)) END ) To reduce index size, instead of SUFFIXES, I am looking for another aka SUFFIXES function but tokenise by whi…

Index from SUFFIXES by whitespace

vsr1 August 9, 2023, 1:02pm 4

See FTS search (match_phrase Match Phrase Query | Couchbase Docs) if anything help full. cc @abhinav

Topic		Replies	Views
Help for Array and like uses together SQL++	33	3697	October 6, 2017
N1QL - Indexes when using tokens to search in array field SQL++	10	777	April 19, 2021
Obtain One Array from N Arrays (possibly with distinct) SQL++	3	1818	October 18, 2016
CB 4.5 N1QL Like '%word%' is slow SQL++ n1ql	14	2293	June 14, 2019
SUFFIXES on SubDocument SQL++ index	2	940	April 18, 2018