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

■ Types of Tuning Analysis

自动的SQL调试是查询优化器的一个新功能,它自动化整个SQL的调试过程。使用

新的增强查询优化器去调试SQL语句,自动化的过程替代手工SQL调优,它是一项

复杂的,重复和耗时的工作。自动SQL调优功能使用SQL调试顾问展示给用户。

这章节包含如下话题:

#查询优化模式

#调试分析的类型

原创粉丝点击