-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: 1.6.1, 1.7.0
-
Component/s: Performance, Querying
-
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.
- is duplicated by
-
SERVER-42104 add flag to query result document indicating a COLSCAN was necessary
- Closed
-
SERVER-50428 Expose diagnostics to client queries
- Closed
- is related to
-
SERVER-42104 add flag to query result document indicating a COLSCAN was necessary
- Closed
- related to
-
SERVER-10448 Revamp explain() formatting
- Closed