[font="Times New Roman"]

Hi,

Store procedures are not compiled every time. Usually execution plan for store procedure is reused.

When there are some changes in input parameters or underlying table from which SP is fetching data, store procedure is recompiled and a new execution plan is created.

Good things that comes with SP are security, less network traffic and SQL injection aviodance.

Regards,

Anil

[/font]