为column1,column2创建索引
select rownum id,a.* from (select * from T ............ order by column1,column2)
where id between 500001 and 501000;
select rownum id,a.* from (select * from T ............ order by column1,column2)
where id between 500001 and 501000;
但是rownum用的有问题
select ..... from
(select rownum id,t.* from a order by col... where rownum<=501000) t1
where t1.id>50000
楼主能不能把测试的结果告诉我
SQL> select * from test order by name,id; ID NAME
---------- --------------------
1 222
1 333
2 333
3 333
3 333
2 4444SQL> select name,id from (select rownum nm,name,id from test order by name,id) a 2 where nm between 1 and 3;NAME ID
-------------------- ----------
222 1
333 1
4444 2
1.create index index_t on t(column1,column2);
2.select * from (select * from T ............ order by column1,column2)
where rownum between 500001 and 501000;