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

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • 1.6.1, 1.7.0
    • Performance, Querying
    • None
    • All
    • Query Execution
    • 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

        Activity

          People

            backlog-query-execution Backlog - Query Execution
            zippy1981 Justin Dearing
            Votes:
            1 Vote for this issue
            Watchers:
            20 Start watching this issue

            Dates

              Created:
              Updated: