Try using an index hint. You need this to avoid the index type_ix and use only index over5.
EXPLAIN SELECT *
FROM test_sw1 USE INDEX (over5)
WHERE meta().id NOT LIKE 'sync:%' AND type = 'user' AND (_deleted = FALSE OR _deleted IS MISSING)
;Try using an index hint. You need this to avoid the index type_ix and use only index over5.
EXPLAIN SELECT *
FROM test_sw1 USE INDEX (over5)
WHERE meta().id NOT LIKE 'sync:%' AND type = 'user' AND (_deleted = FALSE OR _deleted IS MISSING)
;