• 053369


    Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?
    A. The SGA Tuning Advisor
    B. The SQL Access Advisor
    C. The SQL Tuning Advisor
    D. The Memory Advisor

    相关题053-61
      SQL 优化指:分析各个 SQL 语, 并建议 SQL 概要文件, 统计信息, 索引和重构的 SQL 以改善 SQL性能。
      SQL 访问SQL 的全部工作量, 并建索引, 分区和体化视图, 将改善 SQL 工作量的体性能。
      SQL Access Advisor 许 DBA 收集工作负载的全局建SQL 调优顾问是更粒度的, 句。
      SQL Access advisor 的主要功能是建缺少索引和例化视图,但是合任分析建可在 SQL Tuning 顾问程序中使用的 SQL 配置文件。
    DBA 义 SQL Access Advisor 中使用的 SQL,并且可以选择当前 SQL(用的)SQL 集合, 史工作负载或假工作负载
    的工作负载非常有用,因为 DBA 只需要指定参与的表查询SQL Access Advisor 会收集相SQL 语句以建工作负载
    参考:http://www.dba-oracle.com/oracle10g_tuning/t_sql_access_advisor.htm
    SQL 调顾问STA)主要设计用于替动调SQL 语句和加快整个 SQL 调优过程。 SQL Tuning Advisor 研究行不佳的 SQL 语句并根据 CPUI / O 临时间评源消耗。
    SQL 调优顾问STA)使用自动调优优化器(ATO)来分析SQL工作负载使用来自 AWR的数据,并且它生成新索引和物化视图的建议这将减少与麻SQL 语句相关的磁盘 I / O .
      The SQLAccessAdvisor allows the DBA to gather global recommendations for a workload.
      TheSQLTuningadvisor is more granular,tuning a single statement.
      The main functions of the SQL Access advisor is to recommend missing indexes and materialized views, but a comprehensive task analysis will also create SQL Profiles that can be used within the SQLTuning advisor.
      The DBA defines the SQL used in the SQL Access Advisor task, and can choose current SQL,a user-defined set of SQL,a historical workload,or a hypothetical workload.
      A hypothetical workload is very useful because the DBA need-only specify the tables that participate in the queries, and the SQL Access Advisor gathers the appropriate SQL statements to create the workload.

      The SQL TuningAdvisor (STA) is primarily designed to replace the manual tuning of SQL statements and speed up the overall SQL tuning process. The SQL Tuning Advisor studies poorly executing SQL statements and evaluates resource consumption in terms of CPU, I/O, and temporary space.
      The SQL Tuning Advisor (STA) works with the AutomaticTuning Optimizer (ATO)to analyze historical SQLworkload using data from theAWR,andit generates recommendations fornew indexes and materialized views that will reduce the disk I/O associated with troublesome SQL statements.

  • 相关阅读:
    C++中内联函数
    剑指offer62:二插搜索树的第k个节点
    剑指offer63:数据流中的中位数
    剑指offer64:滑动窗口的最大值
    剑指offer65:矩阵中的路径
    剑指offer66:机器人的活动范围
    kmean算法C++实现
    【数组】Minimum Size Subarray Sum
    【数组】Missing Number
    【数组】Product of Array Except Self
  • 原文地址:https://www.cnblogs.com/Babylon/p/7826122.html
Copyright © 2020-2023  润新知