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

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

    • Type: Icon: Task Task
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None

      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.

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

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