解释输出与分布计信息收集.docVIP

解释输出与分布统计信息收集 1. 首先我们运行如下的解释语句 D:\Program Files\IBM\SQLLIB\BINdb2expln -d sample -q select * from employee where empno=000010 -t -g -i 或者是： D:\Program Files\IBM\SQLLIB\BINdynexpln -d sample -q select * from employee where empno=000010 -t -g -i DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 1991, 2007 Licensed Material - Program Property of IBM IBM DB2 Universal Database SQL and XQUERY Explain Tool DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 1991, 2007 Licensed Material - Program Property of IBM IBM DB2 Universal Database SQL and XQUERY Explain T