|
大家看看这个语句怎么优化.表比较大 还有clob字段.
select *
from (select row_.*, rownum rownum_
from (select this_.ID as ID74_0_,
this_.COLUMN_ID as COLUMN2_74_0_,
this_.DEPT_EMP_ID as DEPT3_74_0_,
this_.TITLE as TITLE74_0_,
this_.CONTENT as CONTENT74_0_,
this_.SOURCE as SOURCE74_0_,
this_.HITS as HITS74_0_,
this_.UPDATE_TIME as UPDATE8_74_0_,
this_.CREATE_TIME as CREATE9_74_0_,
this_.TOP_TIME as TOP10_74_0_,
this_.AUTHOR as AUTHOR74_0_,
this_.REPORT as REPORT74_0_,
this_.STATUS as STATUS74_0_,
this_.ATTACH as ATTACH74_0_,
this_.PRE_TITLE as PRE15_74_0_,
this_.SUB_TITLE as SUB16_74_0_,
this_.FOCUS_NEWS as FOCUS17_74_0_,
this_.SUMMARY as SUMMARY74_0_,
this_.KEYWORDS as KEYWORDS74_0_,
this_.PRIORITY as PRIORITY74_0_,
this_.POSTER as POSTER74_0_,
this_.VARIETY_CODE as VARIETY22_74_0_
from KIIIK.TB_ARTICLE this_
where this_.STATUS = :1
order by this_.TOP_TIME desc, this_.ID desc) row_
where rownum <= :2)
where rownum_ > :3 |
|