Sql server xml doc (for explain plan) not clickable like in other tools
When working against sql server db there is sometimes possible to get query result which returns xml document in column. Sometimes that document is explain plan definition. One example of such is when using sp_whoisactive (maintenance tool from Adam Mckanic) then when using the parameter @get_plans = 1 it will show column which contains the plan for the query and in sql server management studio one can just click on it and it will show the plan visually. How do handle this in Data grip? It seems to be an XML document definition which sql server management studio knows to convert to visual plan but Datagrip just sees it as an XML document and it seems to handle it as plain text.
Please sign in to leave a comment.
We've created a feature request to implement this functionality:
https://youtrack.jetbrains.com/issue/DBE-17196/Allow-viewing-plans-in-XML-format
Feel free to upvote so it can get more attention.