影响优化器的另一种方式就是使用查询命令。
Another way to influence the optimizer is to use query directives.
在最后一步,我们添加了一个简单的命令行查询命令。
As a final topic, we added a simple command line query command.
此外,还将讨论优化器的角色,其中包括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.
优化器的行为受三个关键因素的影响: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.
使用EXPLAIN命令查看查询的解释计划。
运行 evms_queryvolumes命令来查询当前挂载的存储。
Run command evms_query volumes to query the current mounted storage. The results should look like this
这些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.
rpm命令可以查询软件包、判断必需的软件以及查看软件包中包含哪些文件。
The RPM command can query individual packages, determine requisite software, and see which files are contained within what package.
这些命令对数据运行算法,或查询有关该数据的信息。
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.
将根据其优先级对基本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.
将所有对象存入数据库后,会执行一个简单的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.
按下execute将在命令结果区域返回查询结果,如图9所示。
Press Execute to return the query result in the command results area, as in Figure 9.
然后在DB 2命令行中输入下面的查询。
要在MongoDB中执行此查询,需要使用清单20中的命令。
To perform this query in MongoDB, you would use the command in Listing 20.
DB 2提供的GUI和命令行工具可以用来查看查询的解释计划。
DB2 provides GUI and command line tools to see explain plan of a query.
清单2 .arq命令指定数据源、SPARQL查询的位置和结果格式。
Listing 2. arq command specifying data sources, location of SPARQL query, and results format.
下一步是创建指定的游标,方法为使用GETCURSOR命令,以及使用必要的SQL查询为游标选择行。
The next step is to create the named cursor, which you do by using the GET cursor command along with the necessary SQL query that selects the rows for the cursor.
PowerGUI会自动记录所有通过菜单执行的脚本,所以你可以通过菜单执行复杂的查询,并查看曾经执行过的命令。
PowerGUI automatically records all scripts executed through the menu, so you can run a complex query through the menu and view the precise commands that were executed.
接下来,查询ssh - agent以在标准输出中生成Bourneshell命令。
Next, query ssh-agent to generate Bourne shell commands on stdout.
第二个命令表明,不能使用标准的fuser选项直接查询底层设备。
The second command shows that you cannot directly query the underlying device by using the standard fuser options.
最后一个命令可以按照ID删除一条特定记录,也可以通过查询删除多条记录。
The last command can delete a specific record by ID or many records through a query.
在pass - through会话中提交的sql语句和命令不会通过联邦查询编译器。
The SQL statements and commands submitted in a pass-through session do not go through the federated query compiler.
您可以用命令locale charmap查询当前语言环境中字符编码的名称。
You can query the name of the character encoding in your current locale with the command locale charmap.
重写后的查询也称为“OptimizedSQL”,它将在使用db2exfmt命令解释语句时出现。
The rewritten query known as "Optimized SQL" is visible when you explain the statement with the db2exfmt command.
此命令更新了系统目录中的统计数据,优化程序使用这些数据来确定成本最低的查询计划。
This command updates the statistics in the system catalogs that the optimizer USES to determine the lowest-cost query plan.
在DB 2中,RUNSTATS TABLEALLINDEX ALL命令会收集统一的统计数据,这其中很多对改善查询性能并不必要。
In DB2, the command RUNSTATS TABLE all INDEX all collects all uniform statistics, many of which may not be necessary for improving query performance.
在DB 2中,RUNSTATS TABLEALLINDEX ALL命令会收集统一的统计数据,这其中很多对改善查询性能并不必要。
In DB2, the command RUNSTATS TABLE all INDEX all collects all uniform statistics, many of which may not be necessary for improving query performance.
应用推荐