Hello,
So I tried this query out via the VSC Exension and got an error back, talking about “planner returned error: bad hint”.
db.movies.aggregate([
{"$match": {"year": { "$gt": 2010}, "countries": "Costa Rica"}},
{"$sort": {"title":1}}],
{"hint":{"countries": 1}, "explain": true}
);
Any thoughts on what’s not right? Is it that the movies db doesn’t have a countries index?
Thanks.
EDIT: Yes, the additional of the index, sorted the problem out