影响优化器的另一种方式就是使用查询命令。
Another way to influence the optimizer is to use query directives.
在最后一步,我们添加了一个简单的命令行查询命令。
As a final topic, we added a simple command line query command.
此标识符本身可以是附加查询命令的生成器。
This identifier can itself be a generator for additional query commands.
此外,还将讨论优化器的角色,其中包括OPTCOMPIND参数、查询命令和内部统计数据。
In addition, it discusses the role of the optimizer, including the OPTCOMPIND parameter, query directives, and internal statistics.
doPOST函数使用服务查询命令、查询输入值及一个回调函数来处理从这些服务返回的结果。
The doPOST function expects the service query command, query input values, and a callback function to process the result returned from the services.
攻击者一旦窃取到数据库的访问权,就可以简单地通过数据库查询命令来获取其感兴趣的的信息。
The attacker can feel the interest information simplify by the fact that the data base inquiry gains the person coming order once stealing right from the visit to the data base.
监测计算机的控制命令或查询命令也可以通过GPRS网传送到遥测仪中,对各个智能传感器实行远程控制。
The control instructions or enquiry of monitoring computer can transmit to remote indicating instrument by GPRS network to carry out long-distance control to every intelligent sensor.
通过视图存取的数据,实际上是通过标准的T -SQL查询命令构成的,而且可以来自许多不同的基础表,甚至其他视图。
The data accessed through a view is actually constructed using standard T-SQL select command and can come from one to many different base tables or even other views.
优化器的行为受三个关键因素的影响:Informix配置文件中OPTCOMPIND参数的值、查询命令和内部统计数据的准确性。
The behavior of the optimizer is influenced by three key factors: the value of OPTCOMPIND parameter in the Informix configuration file, query directives, and the accuracy of internal statistics.
这些命令对数据运行算法,或查询有关该数据的信息。
These commands run algorithms on the data or query for information about the data.
您可以使用DB 2命令行或其他查询工具执行这些语句来创建视图。
You can execute the statement to create this view in a DB2 command line or other query tool.
DB 2提供的GUI和命令行工具可以用来查看查询的解释计划。
DB2 provides GUI and command line tools to see explain plan of a query.
使用EXPLAIN命令查看查询的解释计划。
该查询可以通过DB2命令行界面或图形查询工具以交互方式执行,是一个标准的SQL语句,调用了两个XML 特定的函数。
This query, which can be executed interactively through a DB2 command-line interface or graphical query tool, is a standard SQL statement that invokes two XML-specific functions.
创建索引最直截了当的方式,就是采用可以运行查询的命令行接口。
The most straightforward way to create indexes is using a command line interface that allows queries to be run.
它还提供在命令行中处理查询的简单循环。
It also supplies a simple loop for handling queries on the command line.
您可以使用LISTHISTORY命令查询数据库备份历史。
You can use the LIST HISTORY command to interrogate the database backup history.
查询解释使用EXPLAIN命令查看查询的解释计划。
Query Explain Use EXPLAIN command to see the explain plan of a query.
索引命令发送到主服务器,查询则发送到从服务器。
Indexing commands are sent to the master server and queries are sent to the slave servers.
清单2 .arq命令指定数据源、SPARQL查询的位置和结果格式。
Listing 2. arq command specifying data sources, location of SPARQL query, and results format.
要在MongoDB中执行此查询,需要使用清单20中的命令。
To perform this query in MongoDB, you would use the command in Listing 20.
rpm命令可以查询软件包、判断必需的软件以及查看软件包中包含哪些文件。
The RPM command can query individual packages, determine requisite software, and see which files are contained within what package.
然后在DB 2命令行中输入下面的查询。
按下execute将在命令结果区域返回查询结果,如图9所示。
Press Execute to return the query result in the command results area, as in Figure 9.
这些ioctl命令用于查询接口的状态并对其属性进行操作。
These ioctl commands are used to query the state of an interface and to manipulate its properties.
阅读慢速查询日志最好是通过mysqldumpslow命令进行。
Reading through the slow query log is best done with the mysqldumpslow command.
您可以用命令locale charmap查询当前语言环境中字符编码的名称。
You can query the name of the character encoding in your current locale with the command locale charmap.
在pass - through会话中提交的sql语句和命令不会通过联邦查询编译器。
The SQL statements and commands submitted in a pass-through session do not go through the federated query compiler.
将所有对象存入数据库后,会执行一个简单的find查询(在命令行中指定)并返回一份相匹配结果的List。
After storing all objects to the database, a simple find query (specified in the command line) is executed and a List of matched results is returned.
将根据其优先级对基本DN执行查询操作,如lsuser命令,直到找到了匹配的帐户。
A query operation, such as the lsuser command, will be done to the base DNs according to their priority until a matching account is found.
应用推荐