--------查看执行计划
执行 db2 -tvf # home/sqllib/misc/EXPLAIN.DDL 建立执行计划表
db2 explain plan for "select * from table_name";
-------查看表外键
select * from syscat.references where tabname="table_name";
--------查看执行计划
执行 db2 -tvf # home/sqllib/misc/EXPLAIN.DDL 建立执行计划表
db2 explain plan for "select * from table_name";
-------查看表外键
select * from syscat.references where tabname="table_name";