Using CB CE 4.1 and in the process of evaluating CB EE 4.5 Created secondary indexes on the attributed which are in where clause. However the select statement select * from mybucket where firstname like ‘%bob%’ is very slow… I read that in some of the forum posts that you have fix in 4.5.1 or CB …

CB 4.5 N1QL Like '%word%' is slow

Topic		Replies	Views
N1QL: performance and advanced features SQL++	3	1811	September 6, 2016
Help for Array and like uses together SQL++	33	3686	October 6, 2017
Slow N1QL performance on covered queries SQL++ query , n1ql , index	5	2152	August 8, 2017
N1QL query 'like' takes long time to finish SQL++	1	475	October 8, 2021
Query search like %search% SQL++ query , n1ql , server , index	3	1184	February 6, 2020