db2 Explain 命令



DELETE FROM EXPLAIN_INSTANCE
explain plan for SELECT * FROM LOCAL.TAN
db2exfmt -1 -d DSDB -o start.plan

--Is the sql's performance good?
db2batch -d IRDSDB -f 2.sql -r 2.result -iso CS
--Why it is good/bad?
--Here we can also use Visual Explain
db2expln -d IRDSDB -f 2.sql -t -z ";" -g > 2_before.exp
--Can DB2 give me some good suggestions?
db2advis -d IRDSDB -i 2.sql -n TPCD -m ICMP -o 2.output
请使用浏览器的分享功能分享到微信等