In the msftesql process , the full - text engine query processor processes the query using thesaurus and noise word files , as well as word breakers and stemmers 在msftesql进程中,全文引擎查询处理器将使用同义词库和干扰词文件以及断字符和词干分析器来处理查询。
Set showplan all returns information as a set of rows that form a hierarchical tree representing the steps taken by the sql server query processor as it executes each statement Set showplan _ all将信息作为行集返回,该行集将以层次结构树的形式,表示sql server查询处理器在执行每个语句时采取的步骤。
Set showplan text returns information as a set of rows that form a hierarchical tree representing the steps taken by the sql server query processor as it executes each statement Set showplan _ text将信息作为行集返回,行集形成一个层次结构树,用以表示sql server查询处理器在执行每条语句时所采取的步骤。
An expression that does not use sarg operators does not improve performance , because the sql server mobile query processor has to evaluate every row to determine whether it meets the filter clause 不使用sarg运算符的表达式无法提高性能,因为sql server mobile查询处理器必须评估所有行,以确定是否满足筛选子句。
Sql server developers and administrators can use the provider with sql server integration services , sql server analysis services , replication , and distributed query processor Sql server开发人员和管理员可以将此提供程序与sql server integration services sql server analysis services复制和分布式查询处理器结合使用。
To create useful indexes , you much understand how the data is used , the types of queries and the frequencies they are run , and how the query processor can use indexes to find your data quickly 若要创建有用的索引,您必须了解下列知识:数据的使用方式,查询的类型及其运行频率,以及查询处理器如何使用索引快速查找数据。
Sql server mobile delivers necessary relational database functionality in a small footprint : a robust data store , an optimizing query processor , and reliable , scalable connectivity capabilities Sql server mobile以很小的内存开销提供了所需的关系数据库功能:可靠的数据存储、优化查询处理器,以及可靠、可伸缩的连接功能。
These interfaces define the boundaries of dbms components such as row containers , query processors , and transaction coordinators , which enable uniform transactional access to diverse information sources 这些接口定义了dbms组件的边界,例如行容器、查询处理器和事务处理协调器,使用这些组件可对各种信息源进行统一事务访问。
When a user issues a query , the query processor compares the map to the values specified in the where clause , and builds an execution plan with a minimal amount of data transfer between member servers 用户发出查询时,查询处理器将映射与where子句中指定的值进行比较,然后生成使成员服务器间的数据传输量减到最少的执行计划。