053第42题
42.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning
Set as a part of the workload capturing. What information is captured as part of this process?
(Choose all
that apply.)
A. the SQL text
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)
Answer: ACD
Before running SQL Performance Analyzer, capture a set of SQL statements on the production system that represents the SQL workload which you intend to analyze.
The captured SQL statements should include the following information:
-
SQL text
-
Execution environment
-
SQL binds, which are bind values needed to execute a SQL statement and generate accurate execution statistics
-
Parsing schema under which a SQL statement can be compiled
-
Compilation environment, including initialization parameters under which a SQL statement is executed
-
-
Number of times a SQL statement was executed
相关文章
- Silverlight实用窍门系列:42.读取拖动到控件上的外部txt和jpg文件,多外部文件的拖动【附带实例源码】
- Qt开源作品42-视频监控布局
- 【STM32H7教程】第42章 STM32H7的DMA基础知识和HAL库API
- 【Android笔记42】Android自定义Toast提示信息工具类
- 【目标检测】42、目标检测回顾 | recent advances in deep learning for object detection_2019
- 成功解决sys:1: DtypeWarning: Columns (39,41,42,217) have mixed types.Specify dtype option on import or s
- 100天精通Python(进阶篇)——第42天:pdfplumber读取pdf(基础+代码实战写入Excel)
- 已解决UnicodeEncodeError: ‘utf-8‘ codec can‘t encode characters in position 42-43: surrogates not allow
- [LeetCode] 42. 接雨水 ☆☆☆☆☆(按列、动态规划、双指针)
- 42.第十章 网络协议和管理配置 -- 局域网和TCP/IP 协议栈(三)
- 爬虫日记(42):Flask模板中的if语句
- reactos操作系统实现(42)
- 测试小故事42:假数据
- Crack:amCharts 5: Maps v5.2.42 JavaScript