此外,还将讨论优化器的角色,其中包括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.
此标识符本身可以是附加查询命令的生成器。
This identifier can itself be a generator for additional query commands.
监测计算机的控制命令或查询命令也可以通过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.
运行 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.
您可以使用DB 2命令行或其他查询工具执行这些语句来创建视图。
You can execute the statement to create this view in a DB2 command line or other query tool.
rpm命令可以查询软件包、判断必需的软件以及查看软件包中包含哪些文件。
The RPM command can query individual packages, determine requisite software, and see which files are contained within what package.
将根据其优先级对基本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命令行中输入下面的查询。
DB 2提供的GUI和命令行工具可以用来查看查询的解释计划。
DB2 provides GUI and command line tools to see explain plan of a query.
要在MongoDB中执行此查询,需要使用清单20中的命令。
To perform this query in MongoDB, you would use the command in Listing 20.
清单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.
当它们各自的数组里有相同的索引时,数据查询和更新命令就是相关联的。
A data query and an update command are associated when they have the same index in their respective arrays.
如果有使用动态sql,请务必将命令参数化,也绝对不要在查询字串中直接包含参数值。
If you use dynamic SQL, be sure to parameterize your commands, and never include parameter values directly into the query string.
最后一个命令可以按照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.
应用推荐