Who's Afraid of Performance Statement Reporting?
谁害怕在业绩报表中报告？
The option to turn on the SQL Statement event monitor is not practical because of the overheard involved and the potential performance penalty a high transaction environment could incur.
用于打开SQL语句事件监视器的选项并不实用，由于涉及的开销和潜在的性能损失，会导致一个高事务环境。
That statement was designed to prime the participants' worry that their advanced age would affect their performance.
该声明加重了受测者的担忧，从而使他们相信年龄问题会影响其表现。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义，所以不会影响查询性能。
Although different access paths for the same SQL statement produce the same result set, they most likely do not perform the task with the same level of performance.
虽然相同sql语句的不同访问路径会产生相同的结果集，但是它们很有可能不会通过同样的性能级别来执行任务。
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.
现在，对于由于使用字面值而具有独特性的多个语句，会使用参数把它们整合为单一语句，从而提高应用程序性能。
Without these statistics, the database manager could make a decision that would adversely affect the performance of an SQL statement.
如果没有这些统计信息，数据库管理器可能会做出对sql语句的性能产生不利影响的决定。
With these statistics information database manager could make a decision that would increase the performance of an SQL statement.
数据库管理器通过这些统计信息可以做出决策以提高SQL 语句的性能。
For a given SQL statement, there are often multiple access path choices, and the different access paths usually have different performance characteristics.
对于一个给定的sql语句，往往有多个访问路径选择，而不同的访问路径具有不同的性能特点。
Extensions to the create index statement enable administrators to create full text indexes to help improve the performance of such searches.
对CREATEindex语句的扩展使管理员能够创建全文索引，从而帮助改进这种搜索的性能。
Another important factor that affects SQL statement performance is database statistics.
影响sql语句性能的另一个重要因素是数据库统计。
For optimal performance, it is important to have statement caching turned on and set to a reasonable size.
为了实现最佳性能，启用语句缓存并为其设置一个合理大小很重要。
Typically, in any performance tuning project the first issue is one of problem statement.
通常，任何性能调优项目的首要问题是问题描述。
The key performance benefit of parameterized queries is that the optimizer can formulate an access path that can be reused over repeated executions of the statement.
参数化查询的主要性能好处是优化器可以制定在重复执行语句时能够再使用的存取路径。
From the performance perspective, dynamic SQL statement can be prepared once and executed multiple times, reusing the same database access plan.
从性能的角度来看，动态sql语句只需要准备一次就可以执行多次，可以重用相同的数据库访问计划。
Comprehensive expert advisors not only tune that particular SQL statement, they also recommend tuning activities that improve the overall performance of an entire DB2 SQL workload.
完善的专家建议程序不仅可以调优特定的sql语句，还可以推荐能够改善完整DB 2 SQL工作负载的整体性能的调优行为。
This panel shows the exact SQL statement PDI will use to retrieve data from the performance data selected.
该面板显示PDI从选定性能数据中检索数据所用的具体的sql语句。
Of course you can always use explicit EXISTS predicates and the MERGE statement with a single row, and both will have similar performance.
当然，可以总是对单行使用显式exists谓词和merge语句，两者将获得相似的性能。
After you obtain the SQL statement, you will find that the performance issue is caused by.
在您获得SQL声明之后，您可以找到由下述问题造成的性能问题。
And in a Wednesday statement on Linden's blog, company CEO Mark Kingdon identified "platform stability, viewer performance, lag, inventory management" as priorities in the short term.
在周三林登博客上的声明中，CEOMarkKingdon证实平台稳定性、客户端性能、网络延迟、用户物品管理将是短期内的优先任务。
Although not an official statement of fact or an official benchmark, personal observations of this technology have suggested between 13-15% performance gains on tested hardware in the Toronto LABS.
尽管不是官方声明或官方基准，对该技术的个人观察表明，在Toronto实验室的受测硬件上可获得13- 15%的性能受益。
In order to realize performance gains from this complicated SQL statement DB2 selects a very sophisticated query plan.
为了从这个复杂的sql语句中赚取性能，DB 2选择一个非常精妙的查询计划。
Use the information on this page to analyze the performance of each SQL statement.
使用此页面上的信息分析每个sql语句的性能。
Using the merge statement in this scenario simplifies development and improves performance.
利用本场景中的merge语句将会简化开发工作并能提高性能。
Based on the AccessIntent parameter, the stored procedure can determine how to handle the SELECT statement to avoid a deadlock or otherwise improve the performance.
以accessintent参数为基础，存储过程能决定如何处理select语句，从而避免死锁或提高性能。
The db2batch utility is a great tool for analyzing the runtime performance of queries. In this scenario, we will be using the following SQL statement to perform our analysis.
db 2 batch实用程序是对查询的运行时性能进行分析的好工具。
WebSphere Application Server offers performance benefits, such as statement caching and allows you to access audit log information from any remote location using a Web browser.
WebSphereApplicationServer提供了可以提高性能的优点，例如语句的缓存功能，并且允许用户使用Web浏览器从任意远程位置来访问审核日志信息。
Looking more closely, the statement performance panel displays metrics specific to the statement.
进一步查看，语句性能面板显示了特定于语句的指标。
There was also some discussion of whether solid state drives would have helped improve performance, but there was no conclusive statement about how they might have impacted performance.
还有一些讨论，是关于固态硬盘驱动能否改善性能，但并没有确切的结论说明固态硬盘能够影响性能。
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语句然后预编译它，从而在这条语句被多次执行的情况下大幅度地提升性能。
应用推荐