为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8.1
安全版
DB version: 0x7000c
05134283968-20230110-179227-20033
-05134283968-20230110-179227-20033 Pack1
1-2-192-2023.01.10-179227-20033-SEC

【操作系统】：linux
【CPU】:
【问题描述】*：分页是排序查询速度慢的问题，哪位老师可以看看sql怎么能优化下

SQL
select * from (SELECT C_CREATETIME,C_CREATOR,C_CURRENT,C_OID,C_ORDER,C_PARENT,C_REMARK,C_STATUS,C_VERSION,C_RELATIONID,C_ICON,C_OPENICON,C_LIB,C_SCORE,C_VIEWTIMES,TRANSFERPERSON,C_HISTORY,C_HANDLE,C_DELETETIME,C_DELETEUSER,JHCC,TM,DAGMC,DAGDM,LDDW,DH,JGDM,QZMC,QZH,MLH,AJH,ND,BGQX,FLH,WJBH,JGWT,ML,ZRZ,HH,YS,CWSJ,GDRQ,MJ,BMQX,QWLX,KFZT,TY,QSRQ,ZZRQ,ZYH,ZTLX,BQ,ZTGG,CFWZ,KZBS,JMBS,FZ,YJPC,YJFS,DALX,YWBS,BMRWMC,HDRWMC,JDRWMC,RWH,ZT,DQR,YID,DZDA,JDZT,JDPCH,JDJD,FBZT,FBPCH,FBJD,TRANSFERDEPARTMENT,RWMC,FBWD,TRANSFERPERSTATUS,TRANSFERDATE,RETURNVIEWS,TRANSFEROUTSTATUS,ARRANGE,CALLBACKREASION,TRANSFERRECEIVEPERSON,TRANSFERPERSONNAME,CKZT,TRANSFERINSTATUS,QXZT,C_MONITOR_STATE,C_MONITOR_ITEMNAME,ZGQKSM,ZGJZSJ,UPLOAD_STATUS,GYJBS,NDHBGQX,JDYJ1,JDLY1,JDBS,JDRQ,C_CONVETSTATUS,KZLY,JDR,BMZT,ZCQZT,WJZHLX,SMFBL,SMSCMS,TJZTBH,ZLZ,BZ,C_ISARCHIVING,GDFWJDZT,SJLY,CHECKRESULT,SFYS,GDND,WJXCSJ,DAMLDM,ZJBS,LSH,ZTC,recid,DMM,SRR,SRSJ,DHMM,CZ,XZ,Q,C,Z,ZJDM,NFSFZ,NVSFZ,STFLH,LMMC,AJHM,YH,TDSYZ,ZDBH,RQ,TDZL,QSXZ,ZDBHM FROM DA_MD_358593 WHERE ((C_STATUS = 0) and (C_CURRENT=1)and (((C_PARENT is null or C_PARENT = '' ) ) and (((((ARRANGE = '03' ) ) ) ) ))) and (C_LIB = '40a531b7fb7b49b49970b60ec7086983') ORDER BY C_ORDER ASC, rownum ASC) where rownum <=10