这篇文章通过explain plan(解析计划)解释Microsoft SQL Server 2000 使用SET SHOWPLAN_TEXT ON 所输出内容的意义和用处。
基于12个网页-相关网页
基因组解析计划 Cancer Genome Anatomy Project ; CGAP
癌症基因组解析计划 cancer genome anatomy project
的癌症基因组解析计划 Cancer Genome Anatomy Project
“动态”意味着查询作为字符串发送给数据库引擎；必须对它进行解析，并生成查询执行计划。
"Dynamic" means that the query is sent into the database engine as a string; it must be parsed and have a query execution plan generated.
原本计划将内置轻量级XML解析支持用于MIDP 2.0规范，但最近更改了这一计划。
Built-in lightweight XML parsing support was originally planned for the MIDP 2.0 specification, but the plan has recently changed.
使用绑定参数的原因是让数据库一次解析sql，对后续的重复请求复用生成好的执行计划，这样做节省了CPU时间和内存。
The reason for using binding parameters is to ask the database to parse your SQL once and reuse the generated execution plan for subsequent repeat requests, which saves both CPU time and memory.
应用推荐