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

system Closed November 7, 2023, 11:30pm 8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

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