Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-509

Explain() works by re-generates the query plan: this can affect timing

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None

    Description

      When running a query using the explain() functionality, this will cause the query engine to re-calculate the query plan. This, in turn, can cause some queries to run slower. If you're timing queries, you shouldn't use explain(); if you're explain()ing queries you shouldn't trust the timing.

      This is not called out in the documentation.

      Attachments

        Activity

          People

            sam.kleinman Sam Kleinman (Inactive)
            william.zola@10gen.com William Zola
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11 years, 21 weeks, 1 day ago