这些信息包括响应时间、此事务的sql语句计数、估计的成本、排序统计数据、与锁相关的详细信息等等。
This includes information such as response time, an SQL statement's count of that transaction, cost estimation, sorting statistics, locking related details, and so on.
它们返回高命中率sql语句,例如耗用排序时间最多的语句。
They return heavy hitter SQL statements, for example, the statement that consumed the most sort time.
这些语句可受益于减少排序数目的附加调优,例如添加索引。
Such statements may benefit from additional tuning to reduce the number of sorts, such as adding an index.
哪些SQL语句消耗的CPU、排序和执行时间最多?
What SQL statements are consuming the most CPU, sort, and execution times?
该元素有助于识别执行大量排序的语句。
This element helps to identify statements which are performing large Numbers of sorts.
之前我们曾提到过,代理私有内存包括一些内存池,例如应用程序堆大小、排序堆大小和语句堆大小。
As we have mentioned earlier, the agent private memory includes several memory pools such as the application heap size, sort heap size and statement heap size. (See Figure 1).
TOTAL_SORT _ TIME:该语句已经执行的所有排序的总消耗时间(微秒级)(例如,使用ORDERBY子句的查询语句)。
TOTAL_SORT_TIME: the total elapsed time (in milliseconds) for all sorts that have been executed by the statement (e.g. query statement using ORDER by clause).
INSERTwithVALUES是一个特例,因为它无法从通过SQE执行中受益,因为该语句没有选择标准、分组或排序。
The INSERT with VALUES is a special case because it would not benefit from executing through SQE because the statement lacks selection criteria, grouping or ordering.
merge语句的Informix实现允许灵活地对WHENMATCHED和WHENNOT matched子句进行排序,如清单6所示。
The Informix implementations of the merge statement allow the flexibility of ordering the WHEN MATCHED and WHEN NOT MATCHED clauses, as shown in Listing 6.
TOTAL_SORT:该语句所执行的排序总数目。
TOTAL_SORT: Total number of sorts executed by the statement.
通过报告显示哪些sql语句正在执行,并根据成本值对这些语句进行排序(包括按照时间或CPU使用情况排序),确定长期运行的SQL。
Identify long-running SQL by using reports that show which SQL statements are being executed and which can be sorted by differing cost values, including sort time or CPU.
在仪表板的右边,可以查看事务中的SQL语句,并根据其执行时间对它们进行排序。
On the right side of the dashboard, SQL statements in the transactions can be viewed and sorted on the time they took to execute.
SQL活动汇总报告给出执行的语句的概况,语句按总执行时间排序。
The SQL Activity Summary Report gives you an overview of the executed statements sorted by total execution time.
下面介绍如何配置一个名为SQL的数据组,这个数据组使用两个预定义数据视图来查看sql语句吞吐量和对溢出情况进行排序。
Here's how to configure a data group called SQL that USES two predefined data views to see SQL statement throughput and to sort overflows.
这些统计数据将修复您的违规语句,但有时dba不会像他们所喜欢的那么频繁地重新排序数据。
These statistics will fix your offenders, but sometimes DBAs don't reorder data as frequently as they'd like to.
移除和排序usings (Remove and Sort Usings)——它将为一个项目中所有文件的“using”语句进行排序,并移除其中没有使用的“using”语句。
Remove and sort Usings - This sorts the "using" statements for all files in a project, removing the ones that are not in use.
XQuery添加了一个更加xml化的SQL版本,允许构建查询、对结果进行排序,并在查询中使用实际的where语句。
XQuery adds more of an XML-ized version of SQL, allowing you to build queries, sort and order results, and use actual WHERE statements in your queries.
Disksorts:此sql语句在磁盘上执行排序的数量。
Disk sorts: Number of sorts for this SQL statement that were executed on disk.
为了对所有列应用排序,需要把它们添加到if - then - else语句中。
In order to apply the ordering on all the columns, we will need to add them to the if-then-else statement.
求SQL语句:求数据库内各表大小,并排序列出。
Seeking SQL statement: seeking the tables within the database size, and sorting out.
“添加orderby子句”对话框可以通过指定结果的排序方式,进一步为SQL数据源定义SELECT语句。
Add ORDER by Clause dialog box enables you to further define a SELECT statement for a SQL data source by specifying how the results are sorted.
这种方法主要关注那些对SQL语句生成有重要影响的词汇,并计算可能出现的语义,同时对语义进行可能性排序。
This method regards important words for generating SQL query, computes all possible query meanings, and then ranks these meanings.
ORDERBY(按…排序)语句规定了每个分组(划分)的数据如何排序。
The ORDER BY clause specifies how the data is sorted within each group (partition).
文章从汉字的形象性和英词的功能性,汉语句子的排序结构与英语句子的框架结构及英汉复句中的句序差异等,多方面阐述了英汉不同的思维方式在各自语言中的体现。
The two different modes of thought are embodied in their own language. The article deals with it from various aspects, such as words, sentence structure, sentence order, and so on.
文章从汉字的形象性和英词的功能性,汉语句子的排序结构与英语句子的框架结构及英汉复句中的句序差异等,多方面阐述了英汉不同的思维方式在各自语言中的体现。
The two different modes of thought are embodied in their own language. The article deals with it from various aspects, such as words, sentence structure, sentence order, and so on.
应用推荐