db2 Explain 命令
-
zchbaby2000
2015-06-01 22:19:39
-
数据库开发技术
-
转载
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