I just run an Execution plan ( not a Estimated Execution Plan ). Over (at the right bottom) some normal symbols of the Execution Plan appears a little symbol. That symbol is a yellow circle, with 3 arrows aiming at the left. Could you explain me the meaning of this symbol, please?
Sorry for my english, I hope you easy understand.
Thank you very much
Jonathan
It could be due to parallelism, refer to the books online and this link http://www.codeproject.com/cs/database/sql-tuning-tutorial-1.asp about understanding Execution Plans.
Also try with Estimated execution plan and see whether you get that and if you put your cursor near to that icon you will get the information.
|||Most likely you refer to the symbol which indicates that this step in the execution plan can run in parallel. Run the query again with the MAXDOP(1) hint, and see if the symbol then disappears.
No comments:
Post a Comment