I ran into a weird issue with Mongoshell today , When performing a find on an optional property , nothing is returned , when using {$ne:null} , the documents are returned without any issues. Also , an sparse index was created on that field. I don't understand why ?