UPDATE content SET categories = ARRAY a FOR a IN categories WHEN a != “veg” END WHERE _type=“UserAsset” AND type IN [“IMAGE”,“AUDIO”,“VIDEO”,“SVG”,“FILE”,“PPT”] RETURNING categories How to create a index for the above query… so that it will execute with in miliseconds ?? I have created index like …

Indexing for an Update Query

Marco_Greco February 5, 2019, 12:37pm 2

Do you mean that it is not updating in milliseconds?

Topic		Replies	Views
Using array index to speed up update query SQL++	1	1310	October 23, 2017
Indexing Update Array query SQL++	1	549	March 24, 2020
Slow update operation SQL++ query	6	1143	October 26, 2021
No Index available (for nested object value update) SQL++ index	3	997	September 11, 2019
Bulk documents update using N1QL update Couchbase Server n1ql	8	1314	April 24, 2020