var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Procedure Cache
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.
dynamic sql in proc
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