The statement Batch is currently not supported with set showplan_xml on.

savemightlife 21 Reputation points
2022-11-04T16:04:13.703+00:00

I would like to see the query plan of my SQL query in Synapse work space.
However, when I clicked on query plan i get this error:
The statement Batch is currently not supported with set showplan_xml on.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,683 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bhargava-MSFT 28,956 Reputation points Microsoft Employee
    2022-11-07T22:11:26.797+00:00

    Hello @savemightlife ,

    Welcome to the MS Q&A platform.

    Are you using SSMS? If yes, could you please let me know your SSMS version?

    I can able to view the estimated execution plan and XML plan using SSMS v19.0

    To view the XML plan use the command SET SHOWPLAN_XML ON

    To view the estimated execution plan, you can enable it from SSMS(please see the below screenshot)

    257960-image.png

    258013-image.png