同样是提10万条数据,不同的sql查询时间竟然差那么大,
--sql1
select u.user_id,u.serial_number
from UOP_CRM1.tf_f_user u,UOP_CRM1.tf_f_customer c,UOP_CRM1.tf_f_cust_person p
where u.cust_id=c.cust_id
and u.cust_id=p.cust_id
and u.remove_tag='0'
and u.user_state_codeset='0'
and u.net_type_code='10'
and u.product_id='80000247'
and u.eparchy_code='0311'
and rownum<=100000;
--sql2
SELECT * FROM (select mm.*,rownum rn from(select u.serial_number
from UOP_CRM1.tf_f_user u,UOP_CRM1.tf_f_customer c,UOP_CRM1.tf_f_cust_person p
where u.cust_id=c.cust_id
and u.cust_id=p.cust_id
and u.eparchy_code='0311'
and u.remove_tag='0'
and u.user_state_codeset='0'
and u.product_id='80000247'
and u.net_type_code='10')mm
where rownum<=100000)
where rn>0
同样是查10万条数据,为啥用上分页之后(也是一次性查询10万条数据),查询速率会提高很多,不太明白里面的原理,疑惑ing~~~~~~~