Automatic SQL Tuning Overview 【每日一译】--2013-01-23
来源:互联网 发布:汉斯软件 编辑:程序博客网 时间:2024/04/27 17:33
Automatic SQL Tuning is a new capability of the query optimizer that automates the
entire SQL tuning process. Using the newly enhanced query optimizer to tune SQL
statements, the automatic process replaces manual SQL tuning, which is a complex,
repetitive, and time-consuming function. The Automatic SQL Tuning features are
exposed to the user with the SQL Tuning Advisor.
This section covers the following topics:
■ Query Optimizer Modes
entire SQL tuning process. Using the newly enhanced query optimizer to tune SQL
statements, the automatic process replaces manual SQL tuning, which is a complex,
repetitive, and time-consuming function. The Automatic SQL Tuning features are
exposed to the user with the SQL Tuning Advisor.
This section covers the following topics:
■ Query Optimizer Modes
■ Types of Tuning Analysis
自动的SQL调试是查询优化器的一个新功能,它自动化整个SQL的调试过程。使用
新的增强查询优化器去调试SQL语句,自动化的过程替代手工SQL调优,它是一项
复杂的,重复和耗时的工作。自动SQL调优功能使用SQL调试顾问展示给用户。
这章节包含如下话题:
#查询优化模式
#调试分析的类型
- Automatic SQL Tuning Overview 【每日一译】--2013-01-23
- Automatic SQL Tuning Advisor
- 17 Automatic SQL Tuning
- 16 SQL Tuning Overview
- Overview of Dimensions【每日一译】--20121206
- Overview of Synonyms【每日一译】--20121208
- Overview of Indexes【每日一译】--20121209
- Automatic SQL Tuning in Oracle Database
- 一:SQL tuning 类
- Overview of Oracle Processes【每日一译】--2012-10-11
- Overview of Extents【每日一译】--2012-10-22
- Overview of Segments【每日一译】--2012-10-24
- Overview of Materialized Views【每日一译】--20121203
- Overview of the Sequence Generator【每日一译】--20121207
- Overview of Index-Organized Tables【每日一译】--20121231
- 自动sql调优(automatic tuning)中的 SQL_profile完整例子
- 自动sql调优(automatic tuning)中的 SQL_profile完整例子
- Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
- Java 中获取本机的IP地址
- 5月1日起不支持iPhone 5的应用不准上架或更新 彻底废除UDID技术
- DELL_iDRAC命令简述
- SpringMVC学习笔记(三) --- 映射处理器
- 重写控件时错误解决
- Automatic SQL Tuning Overview 【每日一译】--2013-01-23
- 常用查看Linux系统信息命令
- css固定元素位置(fixed)
- 如何适配iPhone5界面
- CodeSmith 学习(1)简介下载安装
- 学会制作网线
- 详细解析IOS中的CGContextAddArcToPoint方法的使用
- Android代码混淆【亲测】
- SAP HANA: 列式内存数据库评测