d:\>db2 insert into mytab values(1,'test1'),(2,'test2'),(3,'test3'),(null,'test4')
DB20000I SQL 命令成功完成。
d:\>db2 create index mytab_i1 on mytab(id)
DB20000I SQL 命令成功完成。
d:\>db2 runstats on table administrator.mytab on all columns and indexes all
DB20000I RUNSTATS 命令成功完成。
d:\>db2expln -d test -t -q "select distinct id from mytab"
DB2 Universal Database Version 8.1, 5622-044 (c) Copyright IBM Corp. 1991, 2002
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool
DB2 Universal Database Version 8.1, 5622-044 (c) Copyright IBM Corp. 1991, 2002
Licensed Material - Program Property of IBM
IBM DB2 Universal Database SQL Explain Tool