按NAME排序分页select * from (select rownum rowno,* from PEOPLE order by name) where rowno between 1 and 10
select * from (select rownum id,* from PEOPLE where id<21) where id>10;
你在jsp叶面中自然是有页数的,还有每一页有多少条数据,这些在jsp页面中写好,当作参数传入oracle的过程。过程主要部分如下:select * from ( select rownum r,...... from tbname) where r between (页号-1)*页显示数 and 页号*页显示数;你在jsp中调用过程就可以了,这样做既灵活又高效。没问题的。
如果不排序的话, select * from (select rownum id,* from PEOPLE where id<21) where id>10; 性能比较好。 以前讨论过
select * from (select rownum rm,a.* from table_name a order by name) where rm<=n and rm>=m;
如果用 select * from (select rownum rm,a.* from table_name a order by name) where rm<=n and rm>=m; 查询20万条记录(10秒),和不用order by查询()0.89秒,时间相差5--6倍。该怎么办呢?速度太慢了?????????????????????????????????????????????? 必须得用order by,怎样提高速度呢???????????????????????????????????????????????????
如果用(order by name): select * from (select rownum rm,a.* from table_name a order by name) where rm<=n and rm>=m; 查询20万条记录的分页显示(10秒),和不用order by查询()0.89秒,时间相差5--6倍。该怎么办呢?速度太慢了?????????????????????????????????????????????? 必须得用order by,怎样提高速度呢???????????????????????????????????????????????????
建立people表的name字段索引可改善查询性能,提高速度。
BlueskyWide(谈趣者) : 在表people中name是主键,如何该字段建立索引呢? 我用下列语句给该字段建索引不成功??? create index people_index on people(name); ??????????????
对于此表有5000多万记录,如何在jsp中快速分页(在网页中分页显示)?????????????????
最好详细一点
select rownum r,...... from tbname)
where r between (页号-1)*页显示数
and 页号*页显示数;你在jsp中调用过程就可以了,这样做既灵活又高效。没问题的。
select * from (select rownum id,* from PEOPLE where id<21) where id>10;
性能比较好。
以前讨论过
您好:如果要排序的话?该怎么办??
最好支持能同时支持oracle804 oracle805 oracle817
select * from (select rownum rm,a.* from table_name a order by name) where rm<=n and rm>=m;
查询20万条记录(10秒),和不用order by查询()0.89秒,时间相差5--6倍。该怎么办呢?速度太慢了??????????????????????????????????????????????
必须得用order by,怎样提高速度呢???????????????????????????????????????????????????
select * from (select rownum rm,a.* from table_name a order by name) where rm<=n and rm>=m;
查询20万条记录的分页显示(10秒),和不用order by查询()0.89秒,时间相差5--6倍。该怎么办呢?速度太慢了??????????????????????????????????????????????
必须得用order by,怎样提高速度呢???????????????????????????????????????????????????
在表people中name是主键,如何该字段建立索引呢?
我用下列语句给该字段建索引不成功???
create index people_index on people(name);
??????????????