[J.Poornima]

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.

[sudarao]

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