Question
Explain versus production execution: what plan-cache behavior differs?
Answer
Explain generates candidate plans without consulting cached entries and does not cache its winner. Production operations may reuse an active cached plan for the same query shape. Use explain for diagnosis, then validate representative live behavior separately. Applies to self-managed MongoDB and Atlas.