sql tuning advisor和sql access advisor區別
tuning advisor 是對輸入的sql set的執行計劃進行最佳化
accsee advisor 是對sql set當前如果引入索引、分割槽的話,效能有多大的提升,給出建議。
In Oracle 11g, the SQL Access Advisor can generate partitioning recommendations, index creation
recommendations, materialized view recommendations,and materialized view log recommendations. The SQL
Access Advisor is a tuning tool that provides advice regarding the tuning of materialized views, indexes(Btree,
bitmap, and function-based), and materialized view logs, as well as advice on table and index partitioning.
The SQL Access Advisor provides recommendations by analyzing a known workload and other specified
information. SQL Access Advisor does not generate statistics collection recommendations. This task is
performed by the SQL Tuning Advisor.
題目:
In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
Answer: ACDE
accsee advisor 是對sql set當前如果引入索引、分割槽的話,效能有多大的提升,給出建議。
In Oracle 11g, the SQL Access Advisor can generate partitioning recommendations, index creation
recommendations, materialized view recommendations,and materialized view log recommendations. The SQL
Access Advisor is a tuning tool that provides advice regarding the tuning of materialized views, indexes(Btree,
bitmap, and function-based), and materialized view logs, as well as advice on table and index partitioning.
The SQL Access Advisor provides recommendations by analyzing a known workload and other specified
information. SQL Access Advisor does not generate statistics collection recommendations. This task is
performed by the SQL Tuning Advisor.
題目:
In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
Answer: ACDE
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29654823/viewspace-1397338/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQL Access Advisor 與SQL Tuning AdvisorSQL
- 手工執行sql tuning advisor和sql access advisorSQL
- SQL Access Advisor、SQL Tuning Advisor 測試SQL
- SQL Access Advisor!SQL
- SQL TUNING ADVISORSQL
- Oracle 11 sql tuning advisor sql access advisor關閉以及job檢視與停止OracleSQL
- SQL Access Advisor(zt)SQL
- SQL Access Advisor 概要SQL
- sql tuning set/sql tuning advisor(待完善)SQL
- SQL Tuning Advisor簡介SQL
- 使用sql tuning advisor最佳化sqlSQL
- Oracle SQL優化之sql tuning advisorOracleSQL優化
- oracle實用sql(3)--sql tuning advisorOracleSQL
- 使用dbms_advisor來執行sql access advisorSQL
- SQL Access Advisor的 DBMS_ADVISOR.QUICK_TUNE 使用SQLUI
- Sql Tuning Advisor 使用方法SQL
- 深入瞭解SQL Tuning AdvisorSQL
- SQL Tuning Advisor : dbms_sqltuneSQL
- SQL Tuning Advisor使用例項SQL
- sql tuning advisor(STA) 建議 建立sql profileSQL
- Oracle SQL優化之sql tuning advisor(STA)OracleSQL優化
- Oracle優化案例-關閉auto space advisor和sql tuning advisor(十九)Oracle優化SQL
- ORACLE SQL TUNING ADVISOR 使用方法OracleSQL
- Guideline of SQL Tuning AdvisorGUIIDESQL
- oracle SQL最佳化器SQL Tuning Advisor (STA)OracleSQL
- Oracle SQL最佳化之sql tuning advisor(STA)OracleSQL
- Introduction to SQL Tuning Advisor zt自ITPUBSQL
- 使用SQL Profile及SQL Tuning Advisor固定執行計劃SQL
- [原創]ORACLE SQL TUNING ADVISOR 使用方法OracleSQL
- Sql Tuning Advisor的大致過程測試!SQL
- SQL Repair AdvisorSQLAI
- 在EM中使用SQL Access Advisor(SQL訪問建議)優化SQLSQL優化
- 在EM中使用SQL Tuning Advisor(SQL優化建議)優化SQLSQL優化
- Sql最佳化(二十二) 自動調優工具:sql tuning advisor和sql profile介紹SQL
- Oracle自帶工具sql優化集-SQL Tuning Advisor (使用心得體會)OracleSQL優化
- Oracle OCP IZ0-053 Q232(sql access advisor)OracleSQL
- Oracle OCP 1Z0 053 Q253(SQL Tuning Advisor)OracleSQL
- Oracle OCP IZ0-053 Q46(SQL Tuning Advisor Limited)OracleSQLMIT