To: eygle
盖老师,能帮忙分析下这条语句存在什么样的性能问题么?
select * from ( select D_ID as c1, D_SENDERID as c2, D_SENDER as c3, D_FROMMOBILE as c4, D_TOMOBILE as c5, D_RECEIVER as c6, D_CONTENT as c7, D_ENTERDATETIME as c8, D_FINISHDATETIME as c9, D_SENDERIP as c10, D_STATUS as c11, D_NODEINSID as c12 from EOA32092 where (d_status='0' ) where rownum <= 100
From: miger 2008.02.26 17:39
|