(select rownum as xh, t.* from
(
select * from (
SELECT
*
FROM
q_materialfusion
where sjbj = '0'
and ( instr(mc, '1') > 0
OR instr(ssxmmc, '1') > 0
OR instr(ssxtzc, '1') > 0
OR instr(xinghao, '1') > 0
OR instr(gg, '1') > 0)
order by nf desc, mc asc
) where rownum = 1;
这段 SQL 有优化空间吗，数据 200W ，返回需要 2 秒。
