Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-1812

Add the ability to get query results and the query plan in one call

XMLWordPrintableJSON

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.6.1, 1.7.0
    • Component/s: Performance, Querying
    • Labels:
      None
    • Environment:
      All
    • Query Execution
    • Fully Compatible

      .explain() on a query returns the query plan instead of the query itself. It would be nice to be able to get the query results and the execution plan. This would be useful from the shell, as well as from the APIs. SQL Server Management Studio, the GUI that comes with MS SQL 2k5/2k8/2k8R2 has this functionality and its very useful when debugging. It allows you to tweak a query and ensure that the result set did not change in addition to measuring performance.

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            zippy1981 Justin Dearing
            Votes:
            1 Vote for this issue
            Watchers:
            20 Start watching this issue

              Created:
              Updated: