Home > Software engineering >  How do you get a SQL Server Query execution plan in VS Code?
How do you get a SQL Server Query execution plan in VS Code?

Time:12-01

How do you get SQL Execution Plan in VS code? Something like this:

enter image description here

CodePudding user response:

Sorry to say, but you do not.

Getting the raw data is not that complicated..

SET SHOWPLAN_TEXT ON
SET SHOWPLAN_ALL ON
SET SHOWPLAN_XML ON
SET STATISTICS PROFILE ON
SET STATISTICS XML ON -- The is the recommended option to use

But that deos NOT give you the visualization, and that is simply not built into VS Code. An extension WOULD possibly do it - but noone has to my knowledge written that one.

Sorry, sometimes the answer is just "not happening".

  • Related