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-09-01 : 17:57:07
|
Gerard writes "I'm having trouble finding a definitive answer to this question ... I have an ASP page that calls a Server Object (component) to execute a SQL statement (written in a Visual Basic command object). Upon the first execution of the component and SQL statement, does the access path and optimization info get cached on the web server? Or does SQL server have to re-figure out the access path/optimization info each time the SQL statement is executed?. I'm running IIS 4.0 and SQL Server 7.0. Thanks for any help regarding this matter."
|
|
|
|
|
|
SQL caching in web COM components