Gathering DB stats

cat > stats.sql
RUNSTATS ON TABLE schema.table WITH DISTRIBUTION AND INDEXES ALL ALLOW WRITE ACCESS;

db2 -tvf stats.sql
Posted by

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)