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 Advisor 測試SQL
- Oracle 11 sql tuning advisor sql access advisor關閉以及job檢視與停止OracleSQL
- SQL Access Advisor(zt)SQL
- 使用sql tuning advisor最佳化sqlSQL
- Oracle SQL優化之sql tuning advisorOracleSQL優化
- Oracle優化案例-關閉auto space advisor和sql tuning advisor(十九)Oracle優化SQL
- oracle SQL最佳化器SQL Tuning Advisor (STA)OracleSQL
- Oracle自帶工具sql優化集-SQL Tuning Advisor (使用心得體會)OracleSQL優化
- AOP - Advisor
- MYSQL和SQL的區別MySql
- 【SQL】Oracle SQL join on語句and和where使用區別SQLOracle
- openGauss Index-advisor_索引推薦Index索引
- sql:left join和join區別SQL
- sql語句中#{}和${}的區別SQL
- SQL中where和on的區別SQL
- SQL語句中not in 和not exist的區別SQL
- SQL語句中exists和in的區別SQL
- sql中UNION和UNION ALL的區別SQL
- [20191112]SQL Tuning by adding column alias (2).txtSQL
- SQL Server中count(*)和Count(1)的區別SQLServer
- MySQL中普通sql與預編譯sql 區別MySql編譯
- SQL中 where 子句和having子句中的區別SQL
- 在Pandas中 SQL操作:SQLAlchemy和PyMySQL的區別MySql
- 【Python入門教程】SQL和Python有什麼區別?PythonSQL
- ACCESS2016 SQL語句應用SQL
- v$sql,v$sqlarea,v$sqltext區別SQL
- SQL Server新老版本CE區別SQLServer
- John Deere Service Advisor EDL V3 Electronic Data Link Diagnostic Kit
- SQL Server 2019企業版和標準版的區別?SQLServer
- access_token和refresh_token的區別
- Python和access的區別有哪些?Python教程Python
- 2018-07-26 access sql 's Val (function)SQLFunction
- SQL JOIN 中 on 與 where 有何區別SQL
- java.util.Date和java.sql.Date有什麼區別?JavaSQL
- SQL Server 別名(as)SQLServer
- SQL SERVER 日期和時間資料型別及函式 (Transact-SQL)SQLServer資料型別函式
- 【SQL】18 SQL NULL 函式、SQL 通用資料型別、SQL 用於各種資料庫的資料型別SQLNull函式資料型別資料庫
- HighgoDB查詢慢SQL和阻塞SQLGoSQL
- sql devloper 用法的和SQL 編寫SQLdev