宝贝敏敏

回复 hczzhong thank you for your answer

回复 zhmwang 那这样的tabscan，sort有没有办法优化或避免？

回复 leo 这个索引 I_RETORDER_11 是用来关联的吧，RETORD_ITEM_ID是连接列。

回复 leo $db2 "select count(*) from omsadm.SO_RET_ORDER with ur" 1 350966 1 record(s) selected. ＝＝＝＝＝＝＝＝＝＝＝$db2 "select count(distinct SYNCPOSFLAG ) from omsadm.SO_RET_ORDER with ur"

回复 zhmwang 优化级别已经是5 sort和tabscan 是对nljoin后的结果集做，而且是在内存里，应该不会消耗很多cpu和io。

-- DDL Statements for primary key on Table "OMSADM "."SO_ORD" ALTER TABLE "OMSADM "."SO_ORD" ADD CONSTRAINT "PK_ORD" PRIMARY KEY

-- DDL Statements for primary key on Table "OMSADM "."SO_ORDI" ALTER TABLE "OMSADM "."SO_ORDI" ADD CONSTRAINT "PK_ORDI" PRIMARY KEY

-- DDL Statements for primary key on Table SO_RET_ORDER ALTER TABLE "OMSADM "."SO_RET_ORDER" ADD CONSTRAINT "PK_RET_ORDER" PRIMARY KEY ("ROW

感谢楼上两位大哥回帖。统计信息是最新的。db2exfmt如下： DB2_VERSION: 09.07.4 Database Context: Parallelism: None CPU Speed: 2.519169e-07 Comm Speed: 100

sql 如下： select ordi.ORDER_ITEM_ID as orderItemId, ordi.POSORDER_ID as posOrderId, ordi.SAP_ORDER_ID as sapOrderId, ordi.ORDER_TYPE as orderType, ord.ORDER_TIME as orderDate, ordi.STORE_CODE as store