有这样一个查询语句
Select to_char(RSN) RSN,
to_char(SID) SID,
to_char(OID) OID,
PDID,
PRID,
to_char(GSID) GSID,
to_char(RGSID) RGSID,
to_char(PPOID) PPOID,
VERSION,
STARTDATE,
to_char(APOID) APOID,
APTP,
ENDDATE,
to_char(COID) COID,
OLDENDDATE,
to_char(IU) IU,
VERSION,
to_char(SPID) SPID,
to_char(RFID) RFID,
to_char(RLID) RLID,
PRSNT,
OBDL
from T_PO_BB
Where SID = '123456'
And RSN = 100
And (STARTDATE < ENDDATE OR ENDDATE IS NULL)
AND NVL(ENDDATE, SYSDATE + 1) > SYSDATE
order by SPID ASC, PRID, STARTDATE;
相应表有索引
create index IDX_SID_B on T_PO_BB (SID)
create unique index PK_OSN on T_PO_BB (OID, RSN)
在执行的时候CPU占用超过16％，需要优化，各位大侠看看，有何方案？
自己顶一下。。
一起等待。。。superman
