none
how to convert showplan xml to execution plan RRS feed

  • Question

  • hi

    i have the show plan xml but i wanted to convert it to Execution plan so that it is graphically visible.

    1 more thing i saw in the XML as convert_IMPLICIT but all the columns in all the tables are same.

    <ScalarOperator ScalarString="CONVERT_IMPLICIT(varchar(50),[ws3_uat].[dbo].[positions].[customer] as [p].[customer],0)">
                                      <Convert DataType="varchar" Length="50" Style="0" Implicit="1">


    Query:

    "INSERT INTO testSymbolCusip (firmName, accountNumber, symbol,cusip,data_source) SELECT distinct p.broker as firmName, p.customer as accountNumber, CASE WHEN p.short_symbol like 'F.%' then SUBSTRING(p.short_symbol,3,LEN(p.short_symbol)) WHEN p.short_symbol like 'C.%' then SUBSTRING(p.short_symbol,3,LEN(p.short_symbol)) ELSE p.short_symbol END symbol, p.cusip, p.data_source FROM positions AS p, current_overnight_state AS os, brokerage_profiles bp WHERE p.file_date = os.date AND p.broker = os.broker AND p.customer = bp.customer AND os.data_source = p.data_source AND os.table_name = 'positions'" StatementId="1" StatementCompId="1" StatementType="INSERT" StatementSubTreeCost="32.6469" StatementEstRows="1" StatementOptmLevel="FULL">

    we are not passing any parameters in the query except for 'position', please let me know why it is trying implicit convert.

    checked all the tables the customer column is VARCHAR 30 in all the tables except for in testSymbolCusip which is VARCHAR 50

    does it any way hurt the performance

    Tuesday, February 26, 2013 9:40 AM

Answers

All replies

  • Save the xml as .sqlplan then open the .sqlplan in management studio

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker


    Tuesday, February 26, 2013 9:43 AM
  • Thanks V.vt i was able to generate the execution plan is using the Stream Aggregate which seems to be causing the issue
    Tuesday, February 26, 2013 10:07 AM