The Dynamic operator uses a cursor that can see all changes made by others.
Graphical execution plan icon
How to: Display an Actual Execution Plan
Cursor Logical and Physical Showplan Operators
Logical and Physical Operators Reference
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)
Getting SQL Server 2005 Assistance