Post reply

Execution plan icons

  • January 21, 2004 at 12:54 pm

    #106845

    I look at execution plans fairly often in Query Analyzer with the "Show Execution Plan" option.  Today, while troubleshooting a slow query, most of the icons had a smaller icon overlaying the normal ones.  It is a small yellow circle with three arrows in it pointing to the left, positioned over the normal icons in the lower right hand corner.

    Not all the icons had it, but most did.  Some index seeks would have it, some wouldn't, etc. 

    Couldn't find anything online or in BOL about it.  Anyone know what this means? 

  • January 21, 2004 at 1:52 pm

    #491028

    That means the operation is being performed in parallel; i.e. the execution has been split into multiple threads being processed in parallel by multiple processors.



    --Jonathan

  • January 21, 2004 at 2:00 pm

    #491031

    Guess that should have been more obvious to me since we just switched to a multi processor server

  • January 22, 2004 at 1:46 pm

    #491208

    Where can a complete list of the meaning of all the icons be located?

  • January 22, 2004 at 2:03 pm

    #491213

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_5pde.asp

Viewing 5 posts - 1 through 4 (of 4 total)

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