Results 1 to 2 of 2

Thread: Procedure Cache

  1. #1
    Join Date
    Mar 2007
    Posts
    25

    Unanswered: Procedure Cache

    Hi Friends,

    I have a stored procedure that has dynamic sql statements.

    Will a new query plan be generated everytime when I execute the procedure even if I don't use with recompile option? or it will use the existing query plan from the procedure cache?

    Thanks in advance.

    Regards,
    Poornima.

  2. #2
    Join Date
    Mar 2007
    Posts
    72

    dynamic sql in proc

    Hi,
    Sybase does not allow you to compile a stored procedure until it has all the details it needs to build a plan. So you will not be able to have dynamic sql in a proc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •