---
title: "rownum=1000 与 rown&lt;=1000  速度不一样哦！"
author: "winzenghua"
date: "2009-07-15T16:58:00Z"
tags: []
slug: "rownum-1000-rown-lt-1000"
draft: false
lastmod: "2009-07-15T16:58:00Z"
id: 987865
url: "https://java4gis.iteye.com/blog/987865"
---

按常理来讲 rownum=1000 取第1000行的数据 一条

rown&lt;=1000 取1000行数据 多条。

第一个数据量远小于第二条 ，然而比它还慢！

select F\_ADDTIME,F\_PAYCODE,t.f\_note,  
(CASE WHEN l.F\_INOUT=0 THEN F\_PAYMONEY END) AS MEONYOUT,  
(CASE WHEN l.F\_INOUT=1 THEN F\_PAYMONEY END) AS MEONYIN,  
F\_POUNDAGE,F\_HASPAY,F\_CONTENT,F\_ADMINNOTE,F\_ADMINNAME  
from T\_gather\_UserPayLog L  
INNER JOIN t\_base\_user\_pay\_Type T on l.f\_busino=t.f\_id  
WHERE F\_BuySuc=1  
and rownum=1000

SELECT STATEMENT, GOAL = ALL\_ROWSIO cost=274926Time=3425Cardinality=114351052Bytes=13950828344  
COUNT  
FILTER  
HASH JOINIO cost=274926Time=3425Cardinality=114351052Bytes=13950828344  
TABLE ACCESS FULLObject name=T\_BASE\_USER\_PAY\_TYPEIO cost=5Time=1Cardinality=725Bytes=17400  
PARTITION RANGE ALLIO cost=274921Time=3409Cardinality=114351052Bytes=11206403096  
TABLE ACCESS FULLObject name=T\_GATHER\_USERPAYLOGIO cost=274921Time=3409Cardinality=114351052Bytes=11206403096

and rownum&lt;=1000

SELECT STATEMENT, GOAL = ALL\_ROWSIO cost=9Time=1Cardinality=1000Bytes=220000  
COUNT STOPKEY  
HASH JOINIO cost=9Time=1Cardinality=114351052Bytes=25157231440  
TABLE ACCESS FULLObject name=T\_BASE\_USER\_PAY\_TYPEIO cost=5Time=1Cardinality=725Bytes=17400  
PARTITION RANGE ALLIO cost=4Time=1Cardinality=1003Bytes=98294  
TABLE ACCESS FULLObject name=T\_GATHER\_USERPAYLOGIO cost=4Time=1Cardinality=1003Bytes=98294