Post reply

Plans

  • May 24, 2011 at 8:54 am

    #1329124

    http://en.wikipedia.org/wiki/Reentrant_%28computing%29

    It means the same section of code can be executing from one user (or process) and a second user can then use that same code again and start executing it at that same time. It promotes some scalability, since you need less resources for that section of code.

    If it's not re-entrant, then a second copy of the code must be created and resources assigned for the second user to execute it.

  • June 26, 2011 at 12:57 am

    #1344183

    Hesitated over this one. Compiled plans are re-entrant, but the execution contexts derived from them are not. By 'query plan' I guessed the author of the question was referring to the former, and was rewarded with a point.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 2 posts - 16 through 16 (of 16 total)

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