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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-26 : 12:46:22
|
Larry A writes "A stored procedure is parsed, optimized, compiled, and (after the first execution) the execution plan is cached. If the cache is flushed or the SQL Server is restarted, does a stored procedure have any performance advantages on its first execution over an ad hoc query?
Conversely, if an compiled ad hoc query remains in procedure cache, is its performance the same as a stored procedure? Would this vary if the ad hoc query was executed through ADO using the
"Prepared" command property?
What is the Use Procedure for Prepare dynamic ADO connection property?
For all cases, assume identical SQL statments are executed.
Thanks,
Larry A." |
|
|
|
|
|
Store procedure versus ad hoc query performance?