Force n1ql to use an index

SQL++
2

To Use Index query predicate must contain leading index key and subset of Index Condition

SELECT app_uuid
FROM bucket USE INDEX (ix111)
WHERE app_uuid IS NOT MISSING AND ( sub_type = “app”)
ORDER by app_uuid
LIMIT 100

1 Like