ORDER BY in ARRAY_AGG()

Check the query.log that specified at log location https://developer.couchbase.com/documentation/server/current/clustersetup/ui-logs.html
Also try this index

CREATE INDEX idx_card_board_join_2 ON default(owner,name,_id) WHERE ((type = “board”) and (deleted_at is null));

Can you try 5.1.0

1 Like

The index you provided worked! Awesome. I didn’t realize I could place the keys of the SELECT inside the index (if I wasn’t WHERE-ing them). Is that recommended for 5.x?

Making query covered to avoid fetch. Whenever possible you should use covering index to avoid fetch

1 Like