If you need to affect multiple queries, include multiple statement profiles in a single optimization profile.
如果需要影响多个查询,可在一个优化概要文件中包含多个语句概要文件。
Now, multiple statements that had each been unique due to the use of literals will be consolidated into a single statement using parameters to improve application performance.
现在,对于由于使用字面值而具有独特性的多个语句,会使用参数把它们整合为单一语句,从而提高应用程序性能。
Provides a high - level look at statements, including how to have multiple statements on one line, continue a statement over multiple lines, add comments, and check compilation errors.
提供高级查看语句,包括如何使多行语句位于一行,一个语句位于多行,添加注释和检查编译错误。
You can refer to the multiple schemas in a single SQL statement and it will execute within the same connection (no open is required).
您可以在单个sql语句中引用多个模式,该语句将在同一个连接中执行(不需要打开)。
For a given SQL statement, there are often multiple access path choices, and the different access paths usually have different performance characteristics.
对于一个给定的sql语句,往往有多个访问路径选择,而不同的访问路径具有不同的性能特点。
The federated server automatically generates distributed requests to multiple data sources in response to a single application SQL statement.
为响应一个应用程序SQL 语句,联邦服务器自动生成到多个数据源的分布式请求。
The statement that causes a triggering event might affect multiple rows in the database.
引起触发事件的语句可能会同时影响数据库中的多行。
With a federated system, you can use a single SQL statement to send distributed requests to multiple data sources.
有了联邦系统,便可以使用一条SQL语句将分布式请求发送到多个数据源。
If you need to run a statement across multiple lines, the continuation marker is a single backslash.
如果需要跨多个行运行一条语句,只需要使用反斜杠作为续行符。
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 from component of a SELECT statement indicates from which table (or multiple tables) the data will be extracted.
select语句的FROM组件指明将从哪个表(或多个表)中提取数据。
You have seen in update 9 that you can include multiple update operations for the same document in the MODIFY clause of a single update statement.
在更新9中已经看到,在一个更新语句的modify子句中可以包含对同一文档的多个更新操作。
When the BULK COLLECT clause is included, the statement can return multiple rows; the variable in the INTO clause must be an array, and each row is stored in an array element.
在包括BULKCOLLECT子句后,该语句可返回多行;INTO 子句中的变量必须是阵列,且每一行存储在一个阵列元素中。
A SELECT statement can have multiple columns listed following the SELECT keyword.
在SELECT关键字之后,select语句可以列出多个列。
The task here may have been trivial, but this could just as easily have been an SQL statement that spanned multiple tables, executed triggers, and so on.
这里展示的任务可能是微不足道的,但它也能轻松处理跨多个表、执行触发器等的SQL语句。
As a part of the changes in JDBC 3.0, the specification allows the Statement interface to support multiple open ResultSets.
作为JDBC 3.0规范中改变的一个部分,规范将允许Statement接口支持多重打开的ResultSets。
The import statement can import multiple classes and optionally rename them.
import语句可以导入多个类并可以重命名它们。
Rails will use a JOIN SQL statement or a strategy in which multiple queries are performed.
Rails将使用一个JOINsql语句或一个执行多个查询的策略。
If the WHERE clause of an SQL statement applies multiple predicates, as follows.
如果sql语句的where子句使用了多个谓词。
If the multiple measures apply their aggregation functions on the same dimensions and in the same order as each other, the measures can all be calculated in the same statement.
如果多个度量将它们的聚合函数应用于同样的维,而且次序相同,那么可以在同一个语句中计算这些度量。
With a federated database, you can use a single SQL statement that joins data from multiple data sources, including the federated database itself.
凭借联邦数据库,您可以使用单独一条sql语句连接来自多个数据源的数据,包括联邦数据库本身。
Multiple slices of data can be returned in a single query by using grouping sets or super-groups (such as ROLLUP) in the GROUP-BY clause of the SQL statement.
通过在sql语句的GROUP BY子句中使用多个分组集或超级组(比如rollup),可以在一个查询中返回数据的多个切片。
This form of batching is restricted to single tables and to multiple executions of the same SQL statement as long as the statement has input parameters.
这种形式的批处理仅限于单个表以及同一sql语句的多个执行,前提是该语句有输入参数。
A prepared statement allows you to take a commonly used SQL statement and pre-compile it, thereby dramatically improving performance if the statement is executed multiple times.
预备语句允许您用一条常用的sql语句然后预编译它,从而在这条语句被多次执行的情况下大幅度地提升性能。
As illustrated in Figure 1, by fetching multiple rows, your applications reduce the number of SQL calls and can fetch a rowset using a single fetch statement.
如图1所示,通过获取多个行,应用程序减少了SQL调用,并且可以使用一个fetch语句获取行集。
The key is that the SQL statement in the prepared statement references the current position of the cursor, so you can execute it multiple times and update different rows.
关键是准备好的语句中的sql语句会引用游标的当前位置,所以您可以多次执行它,并更新不同的行。
From the performance perspective, dynamic SQL statement can be prepared once and executed multiple times, reusing the same database access plan.
从性能的角度来看,动态sql语句只需要准备一次就可以执行多次,可以重用相同的数据库访问计划。
The batch update feature improves the performance of a single statement that is executed multiples times, with multiple value Settings.
通过设置多个值,批量更新特性提高了需要多次执行的语句的性能。
I may have the same dynamic SQL statement in each interval, if it ran multiple times.
如果一个动态sql语句运行了多次,我可能在每个时间段内拥有相同的动态sql语句。
That implies that the function is called multiple times during the execution of the SQL statement.
这意味着在sql语句的执行期间,该函数会被多次调用。
应用推荐