第一种:
select * from HT_SUSPINFO a,
(
SELECT XLH FROM
(
SELECT ROWNUM RN ,A.XLH
FROM
(
select xlh from (
(select XLH,bksj from HT_SUSPINFO t
where bksj>(sysdate -10 )
and HPHM like '浙%'
order by bksj desc) A
)
WHERE RN >= 0 and RN<=500
) b
where a.XLH =b.xlh 第二种:
select * from HT_SUSPINFO a,
(
SELECT XLH FROM
(
SELECT ROWNUM RN ,c.XLH
FROM (select xlh,hphm from(select XLH,hphm from HT_SUSPINFO t
where bksj>(sysdate -10 )
order by bksj desc) A) c
where c.hphm like '浙%'
)
WHERE RN >= 0 and RN<=500
) b
where a.XLH =b.xlh 第一种两个条件 第二种先过虑 在查询条件二数据库oracle9 数据:170w++ ,我测试情况 第二种比第一种快很多,第一种查询很久没有结果,受不了就停下它了,第二种 大概0.04s左右,以前一直认为第一种快,请高手解答下!谢谢
select * from HT_SUSPINFO a,
(
SELECT XLH FROM
(
SELECT ROWNUM RN ,A.XLH
FROM
(
select xlh from (
(select XLH,bksj from HT_SUSPINFO t
where bksj>(sysdate -10 )
and HPHM like '浙%'
order by bksj desc) A
)
WHERE RN >= 0 and RN<=500
) b
where a.XLH =b.xlh 第二种:
select * from HT_SUSPINFO a,
(
SELECT XLH FROM
(
SELECT ROWNUM RN ,c.XLH
FROM (select xlh,hphm from(select XLH,hphm from HT_SUSPINFO t
where bksj>(sysdate -10 )
order by bksj desc) A) c
where c.hphm like '浙%'
)
WHERE RN >= 0 and RN<=500
) b
where a.XLH =b.xlh 第一种两个条件 第二种先过虑 在查询条件二数据库oracle9 数据:170w++ ,我测试情况 第二种比第一种快很多,第一种查询很久没有结果,受不了就停下它了,第二种 大概0.04s左右,以前一直认为第一种快,请高手解答下!谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货