0
SQL 大佬来救命
source link: https://www.v2ex.com/t/941922
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
select * from
(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 < 501
) t) where xh >= 1;
这段 SQL 有优化空间吗，数据 200W ，返回需要 2 秒。
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK