All Forums Database
asarkar 3 posts Joined 09/12
09 Apr 2014
Performance wise which one is better Dynamic or Static Query ?

Hi ,
Can anybody please tell me which one is better performance wise ... Dynamic or Static Query ?
I have a procedure full of dynamic queries which all can be written as static queries.
But, not sure if it is worth the effort.
I have created sample procedures and tried to measure the performance . But , did NOT notice any significant difference between them .
Please help.
Thanks,

 

You must sign in to leave a comment.