14:36:47 SQL> select x.owner,x.object_name,x.object_id,x.status from (select rownum rn,a.* from test a) x where x.rn between 1 and 20;
Elapsed: 00:00:00.01
Elapsed: 00:00:00.01
Execution Plan
----------------------------------------------------------
Plan hash value: 1984214786
----------------------------------------------------------
Plan hash value: 1984214786
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1607K| 174M| 4992 (3)| 00:01:00 |
|* 1 | VIEW | | 1607K| 174M| 4992 (3)| 00:01:00 |
| 2 | COUNT | | | | | |
| 3 | TABLE ACCESS FULL| TEST | 1607K| 64M| 4992 (3)| 00:01:00 |
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1607K| 174M| 4992 (3)| 00:01:00 |
|* 1 | VIEW | | 1607K| 174M| 4992 (3)| 00:01:00 |
| 2 | COUNT | | | | | |
| 3 | TABLE ACCESS FULL| TEST | 1607K| 64M| 4992 (3)| 00:01:00 |
----------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
---------------------------------------------------
1 - filter("X"."RN"<=20 AND "X"."RN">=1)
Select
Tname,
Tabtype
FROM
(Select
Tname,
Tabtype,
Rownum Rn
FROM
(SELECT * FROM Tab ORDER BY Tname
)
WHERE rownum <=150
)
WHERE rn>=100;
Tname,
Tabtype
FROM
(Select
Tname,
Tabtype,
Rownum Rn
FROM
(SELECT * FROM Tab ORDER BY Tname
)
WHERE rownum <=150
)
WHERE rn>=100;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-669904/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-669904/