Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gürkan Alkan
Starting Member
7 Posts |
 Posted - 2009-02-24 : 13:46:38
|
| Hi everyone.I want to ask a question: What does pre-optimized stored procedures mean?I've read a book and it lists the advantages of stored procedures. "Because of Pre-optimization and pre-compilation, stored procedures gain time". I can't understand what pre-optimization means.Is there anyone know what it means..?-->Gürkan Alkan<--Istanbul Üniversitesi Bilgisayar Mühendisligi |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 13:51:02
|
| Means the plan is stored in Procedure Cache and is faster when doing this. |
 |
|
|
Gürkan Alkan
Starting Member
7 Posts |
Posted - 2009-02-24 : 13:53:29
|
quote:
Originally posted by sodeep
Means the plan is stored in Procedure Cache and is faster when doing this.
Thank you "sodeep" for your reply.What do you mean with "plan" ?-->Gürkan Alkan<--Istanbul Üniversitesi Bilgisayar Mühendisligi |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 14:01:44
|
quote:
Originally posted by Gürkan Alkan
quote:
Originally posted by sodeep
Means the plan is stored in Procedure Cache and is faster when doing this.
Thank you "sodeep" for your reply.What do you mean with "plan" ?-->Gürkan Alkan<--Istanbul Üniversitesi Bilgisayar Mühendisligi
doorway to output. |
|
|
|
|
|
|
About Stored Procedures