Performance wise which one is better Dynamic or Static Query ?

Database

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,