首页 › DB2 › DB2导出所有table的runstat sql

dmewy 发表于 2013-1-13 18:53:26

DB2导出所有table的runstat sql

SELECT 'runstats on table $1'||'.'||TABNAME||' on all columns with distribution and detailed indexes all allow write access;' FROM SYS
CAT.TABLES WHERE TABSCHEMA='$1' and TYPE in ('T','S') order by 1" >> $SqlFile
 
 
其中$1是schema

查看完整版本: DB2导出所有table的runstat sql