为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
DB Version: 0x7000c
【操作系统】：win10
【CPU】: i7
【问题描述】*： 用（select top_sql_text,start_time from V$SQL_HISTORY y）查询，都超过4秒,有没有优化空间了

– 第一条 page
select *
from
(
select ROW_NUMBER() OVER(ORDER BY djsj desc) NUM,
J.DJSJ, J.XFXSMC, J.DJJGMC, J.NRFLMC, J.XFMDMC, J.CFXFBZ, J.XFXS,
J.NRMYDBZ,J.SJRS,
j.XFJBH,r.XM,j.GKXX,j.XFRQ,j.XBJZSJ,j.WTSDMC,j.XFSXID,j.XFJZT,j.TSNR,
r.ZZ,sjh,zjhm,sxr,xfyymc,ssxtmc,pt
from YW_XFJ j, YW_XFR r
WHERE j.XFJZT = 0 AND j.xfjbh=r.xfjbh AND r.xh=1
AND DJRID=?
AND YYID = ?
AND XFXS = ?
)A
WHERE a.num>? AND a.num<=?

– 第二条 count
select count(*)
from YW_XFJ j join YW_XFR r
on j.xfjbh=r.xfjbh
WHERE XFJZT = 0
and r.xh=1
AND j.YYID is null
AND PT in ( ? )
AND (DFJRID IS NULL OR DFJRID = ?)
AND DJJGID = ?
AND XFXS = ?
ORDER BY djsj DESC