现在要执行这样的查询语法,来得到结果集中的从指定位置处开始的20条记录 select a,b,c,x,y from A,B where A.c=B.z and a.rowid not in(select a.rowid from A,B where A.c=B.z and rownum <12345600) and rownum <=20 order by A.b 如果不进行索引,就10000条记录查询,用20分钟,现在的问题是,对于这样的查询要求,如何建立索引......在线等,分不够开贴另给
select * from (select a,b,c,x,y from A,B where A.c=B.z and rownum <=12345620) minus select * from (select a,b,c,x,y from A,B where A.c=B.z and rownum <=12345600)
