This is going to help you understand why those queries used CQE.
这将有助于理解为什么那些查询使用CQE。
One analysis approach is to select the Summary option for CQE queries.
一种分析方法是针对CQE查询选择Summary选项。
Table 1 lists the remaining reasons why CQE would be used on IBM I 6.1.
表1列出在IBMi 6.1上使用CQE的其他原因。
To understand the reason for CQE use, you will need to examine the associated 3014 record.
为了理解使用CQE的原因,需要查看相关的3014记录。
The overview information helps bound how important this CQE versus SQE use question is to your environment or application.
概述信息有助于确定 CQE与 SQE 的使用对于环境或应用程序的重要性。
Use the enhancements and tooling described in this article to understand the scope of CQE activity and consider removing any impediments to SQE usage.
使用本文描述的增强和工具,理解CQE活动的范围,并考虑克服一切障碍转为使用SQE。
This article explains how to collect an SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE.
本文解释如何收集SQL性能监视器,以及理解很多SQL查询在如何使用SQE,为什么其他sql语句继续使用CQE。
Once you decide that some CQE use analysis is warranted, the different reasons for CQE use will dictate whether any actions can be taken to shift more query engine work to SQE.
对CQE的使用进行分析后,可以根据使用CQE的不同原因来判断是否可以采取行动将更多查询引擎工作转换为SQE。
Once you decide that some CQE use analysis is warranted, the different reasons for CQE use will dictate whether any actions can be taken to shift more query engine work to SQE.
对CQE的使用进行分析后,可以根据使用CQE的不同原因来判断是否可以采取行动将更多查询引擎工作转换为SQE。
应用推荐