[20220217]完善tpt gts.sql脚本.txt

--//有时候不小心使用gts分析生产系统的表,选择FOR TABLE FOR ALL COLUMNS SIZE 1,导致直方图消失.修改采用repeat,这样更加安全
--//一些.
--//method_opt=>'FOR TABLE FOR ALL COLUMNS SIZE 1'为method_opt=>'FOR TABLE FOR ALL COLUMNS SIZE REPEAT'.

-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.

prompt Gather Table Statistics for table &1....
exec dbms_stats.gather_table_stats(null, upper('&1'), null, method_opt=>'FOR TABLE FOR ALL COLUMNS SIZE REPEAT', cascade=>true, no_invalidate=>false);

ITPub博客

[20220217]完善tpt gts.sql脚本.txt

最新文章