Post reply

Sql server Execution Plan table format

  • January 19, 2023 at 10:48 am

    #4139472

    Hi

    I have searched on net but didn`t found much its possible to have output of sql server execution plan in table format ????

    I mean non-graphical dbms like oracle/mysql must giving data in table format only .So its same possible in sql server too.

    Large/complex query execution plan are difficult to read so if we can get same in table format it would good

    this is not specific to any edition

    Thanks

    Anoop

  • January 19, 2023 at 1:32 pm

    #4139547

    You have a couple of options, neither of which is straight to a table.

    First, you can output a text only execution plan. No XML. No graphical whatever. You can then search that or do what you need.

    Second, you can query the XML from an execution plan. You can do straight up XPath queries. Example here. Or, better still, take advantage of DBATools and use their XML shredding mechanisms to pull the plan into tables.

    I don't know any other way to do it.

    My question back to you, what's the table give you that you don't have?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply