Does a Cursor implement an execution plan ?

Hello,

Agree with Olaf its strange question,whatever query comes optimizer either uses cached plans or creates one for it.

In BOL:

The DECLARE CURSOR statement is the root of the graphical execution plan tree, with its related statement as a child or node

see below links for help

http://technet.microsoft.com/en-us/library/ms178071(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/ms181033(v=sql.105).aspx

graphical execution plan for cursor

---

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers