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

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: 1.6.1, 1.7.0
    • Fix Version/s: Backlog
    • Component/s: Performance, Querying
    • Labels:
      None
    • Environment:
      All
    • Backwards Compatibility:
      Fully Compatible

      Description

      .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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated: