create table t as select * from dba_objects;
execute dbms_stats.gather_table_stats('SCOTT','T');
DECLARE
task_name VARCHAR2(30);
BEGIN
task_name := 'My Task3';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, task_name,
'select * from scott.t where object_id = 123');
END;
/
SET LONG 100000
SET PAGESIZE 50000
SELECT DBMS_ADVISOR.get_task_script('My Task3') AS script. FROM dual;
SCRIPT
--------------------------------------------------------------------------------
Rem SQL Access Advisor: 版本 10.2.0.1.0 - 正式版
Rem
Rem 用户名: SYS
Rem 任务: My Task3
Rem 执行日期: 11/03/2009 16:54
Rem
CREATE INDEX "SCOTT"."T_IDX$$_00760001"
ON "SCOTT"."T"
("OBJECT_ID")
COMPUTE STATISTICS;
execute dbms_stats.gather_table_stats('SCOTT','T');
DECLARE
task_name VARCHAR2(30);
BEGIN
task_name := 'My Task3';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, task_name,
'select * from scott.t where object_id = 123');
END;
/
SET LONG 100000
SET PAGESIZE 50000
SELECT DBMS_ADVISOR.get_task_script('My Task3') AS script. FROM dual;
SCRIPT
--------------------------------------------------------------------------------
Rem SQL Access Advisor: 版本 10.2.0.1.0 - 正式版
Rem
Rem 用户名: SYS
Rem 任务: My Task3
Rem 执行日期: 11/03/2009 16:54
Rem
CREATE INDEX "SCOTT"."T_IDX$$_00760001"
ON "SCOTT"."T"
("OBJECT_ID")
COMPUTE STATISTICS;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/104446/viewspace-566842/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
