The key to HSQLDB's simplicity is the serialization of SQL statement execution.
造成 HSQLDB简单性的关键因素是SQL语句执行的顺序化。
The resulting page displays a detailed profile of an SQL statement execution, selected through drill down.
产生的页面显示sql语句的详细执行情况。
You can create indexes on one or more columns of a table to speed SQL statement execution on that table.
用户可以在表的一列或数列上建立索引,以提高在此表上执行sql语句的性能。
The static SQL statement is pre-compiled and bound to a package before execution.
静态SQL语句是在执行之前预编译并绑定到一个包上的。
Information about all SQL statements executed before the lock-timeout event in the participating transactions, such as statement text, isolation level used, order of execution, and so on.
在参与事务中的锁超时事件前执行的所有sql语句信息,如语句文本、使用的隔离级、执行顺序等等。
This file is cumulative, in other words, if you have multiple SQL queries after SET EXPLAIN on statement, each query execution plan and its costs would be appended to this file until it is removed.
该文件是累积的,换言之,如果SETEXPLAINON语句之后有多个SQL查询,每个查询的执行计划及其成本都会被追加到文件中,直到将之删除。
The execution time for an SQL statement is the time required to go through all three phases.
一个sql语句的执行时间是完成上面三个阶段所需的时间。
Listing 9 contains the same three-way join SQL statement that was used in Listing 1 to introduce the concept of access paths and query execution.
清单9包含相同的三路联接sql语句,其用在清单1上以介绍访问路径和查询执行的概念。
For SELECT queries, the text of the remote SQL statement can be found in the details associated with the SHIP operator in the query execution plan.
对于SELECT查询,远程sql语句中的文本可以在查询执行计划中与SHIP操作符相关的细节中找到。
A good access plan is key for the fast execution of an SQL statement.
好的访问计划对于sql语句的快速执行至关重要。
That implies that the function is called multiple times during the execution of the SQL statement.
这意味着在sql语句的执行期间,该函数会被多次调用。
The execution time of an SQL statement is 4 ms.
一个SQL语句的执行时间为4毫秒。
Options are provided to check the syntax of the SQL defining the view as well as to test the execution of this statement.
提供了选项来检查定义视图的sql语句的语法并测试语句的执行。
The null indicator values are populated during the execution of the SQL FETCH statement.
空指示符值在SQLFETCH语句执行过程中填充。
To view the details of each execution of the SQL statement, click on Drill down.
要想查看每次执行此sql语句的详细信息,单击Drill down。
Avoiding the prepare phase especially pays off if an SQL statement is executed many times and if the prepare phase makes up a significant portion of the statement's overall execution time.
避免准备阶段在下面两种情况下最有用:一是sql语句被多次执行;二是准备阶段需要的时间占语句总执行时间的很大一部分。
The query drill down feature helps determine the length of an SQL statement, the resources each statement USES, the length of the statement execution, the length of the resources wait time and so on.
查询钻取特性有助于判断sql语句的长度、每个语句使用的资源、执行语句的时间长度、等待资源的时间长度等等。
Options are available to check the syntax of the SQL defining the view as well as to test the execution of this statement.
它具有可用于检查定义视图的sql语法和测试此语句执行情况的选项。
The time required for the prepare phase of the SQL statement makes up a significant portion of the statement's overall execution time.
准备阶段需要的时间占语句总执行时间的很大一部分。
The direct statement execution method includes additional logic to strip the data after the where clause in the SQL statement.
直接的语句执行方法包括:sql语句中在where子句之后剥离数据的附加逻辑。
You can identify a table by its name or by the quantifier number in the optimized SQL statement shown in the execution plan produced by the db2exfmt tool.
可以根据表名或经过优化后的sql语句中的限定符(quantifier)编号识别表,sql语句显示在由db 2 exfmt工具生成的执行计划中。
Generates a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is useful to monitor and tune the performance of DML statements.
该语句工具主要是研究统计sql语句的执行计划并生成报告,进而对dml语句进行检测和优化。
Generates a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is useful to monitor and tune the performance of DML statements.
该语句工具主要是研究统计sql语句的执行计划并生成报告,进而对dml语句进行检测和优化。
应用推荐