search

microsoft / vscode-mssql

Visual Studio Code SQL Server extension.
Other
1.54k stars 459 forks source link

Queryplan #375

Closed fhelje closed 1 month ago

fhelje commented 7 years ago

Any plans to add queryplan to the result?

erickangMSFT commented 7 years ago

This is a backlog item and we need to design new or find a way to leverage a showplan implementation in SSMS or one existed for Azure SQLDB in the previous portal (SAMP). No clear direction is set yet. This is also a good candidate for an extension. With SET SHOWPLAN_XML ON, the XML result is returned in the result view and the mssql extension opens the xml in the editor by clicking it. An extension may be possible to open it and render a graphical representation similar to markdown preview. -thinking loud-

fcatae commented 7 years ago

Can we add a basic support for query plan using SET SHOWPLAN_TEXT and SHOWPLAN_ALL? This returns a formatted plain text.

erickangMSFT commented 7 years ago

View as Text is a backlog item that will help user to see the text content more efficiently. The same scenario applies to sp_helptext as well. A simple UI that can toggle result in grid and result in text without re-executing the query would be ideal in this case.

Mnior commented 2 months ago

I see the duplicate task #17850 as resolved in the October backlog.

cssuh commented 1 month ago

Added in https://github.com/microsoft/vscode-mssql/pull/17983