I have a real time sla for text search queries of not greater than 30 ms. I have 400 thousand documents. I have regex search queries of the type any 3 letters of firtname like MAT and any four letters of last name like DLLS. the global secondary indexes take far too too much time as its a like …

Optimize Query to get 30 ms performance . Array indexing

vsr1 February 2, 2019, 4:21am 2

Topic		Replies	Views
Help for Array and like uses together SQL++	33	3683	October 6, 2017
Index for SPLIT or SUFFIXES on nested field SQL++ query , index	3	960	April 21, 2021
N1ql like query indexes SQL++	2	735	February 27, 2020
N1QL query taking more time to execute SQL++	6	882	October 24, 2018
Create Secondary Index on Array SQL++ index	14	2891	October 27, 2017