Mongo servers can be run in a mode that rejects the query with an error if it would result in a row scan. Very useful for safely avoiding bad queries slamming your server.
Some "normal" SQL dbs can, at the very least, be configured to log this. Which is pretty great when you consider some can't.