not in改为 not exists性能大幅度提升
摘要：
1.使用not inSELECT b.DEVICE_ASSET_ID FROM HisDataKWH a,dms_tr_device b where a.rq='2009-1-1 0:00:00'and a.dev_id=b.tr_id and b.DEVICE_ASSET_ID not in (select d.DEVICE_ASSET_ID from HisDataKWH c,dms_tr_d... 阅读全文
posted @ 2009-10-23 16:16 highmayor 阅读(430) 评论(0) 推荐(0) 编辑
