过程缓存 meaning in English
procedure cache
Examples
- If there are any execution plans in the procedure cache that reference the table , alter table marks them to be recompiled on their next execution
如果过程缓存中存在引用表的执行计划, alter table会将这些执行计划标记为下次执行时重新编译。 - When any sql statement is executed in sql server 2005 , the relational engine first looks through the procedure cache to verify that an existing execution plan for the same sql statement exists
在sql server 2005中执行任何sql语句时,关系引擎将首先查看过程缓存中是否有用于同一sql语句的现有执行计划。