New answers tagged

0

So it seems special readWrite privileges are needed to execute mapReduce on system.profile collection. So I got the query to work eventually after checking through: https://docs.mongodb.com/manual/tutorial/manage-users-and-roles/


3

Because you have no suitable index on the table, you get a full table scan. The table scan is going parallel, which means that access is happening out-of-order. You could solve this by using OPTION(MAXDOP 1), but that is just a band-aid. Your best bet is to create an index to serve this query, the idea being that the query only needs to do a point lookup on ...


Top 50 recent answers are included