informix performence

hi: I have three table:putlsz,satfl,putxym,I write such SQL ,it perform a long time,how to modify it!thanks very much. select * from putlsz where ( rq < ? or ( rq = ? and sj <= ? ) ) andqsrq< ? and ( yxbz matches "1*" or yxbz matches "*1" or yxbz matches "3*" or yxbz matches "*3" ) and jym in ( select jybm from satfl ) and xym in ( select dm from putxym where xd = "0" ) order by jgbm , rq , zjlsh --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---

Please post a schema of the various tables. That would help greatly. John Carlson Informix DBA WHSmith USA wsf@ccbzj.com wrote: > > hi: > I have three table:putlsz,satfl,putxym,I write such SQL ,it perform > a long time,how to modify it!thanks very much. > select * from putlsz where ( rq < ? or ( rq = ? and sj <= ? ) ) and> qsrq< ? and ( yxbz matches "1*" or yxbz matches "*1" or yxbz matches > "3*" or yxbz matches "*3" ) and jym in ( select jybm from satfl ) and > xym in ( select dm from putxym where xd = "0" ) order by jgbm , rq , > zjlsh > > --== Sent via Deja.com http://www.deja.com/ ==-- > ---Share what you know. Learn what you don't.---