解决Oracle分页查询中排序与效率问题(国外英语资料).docVIP

解决Oracle分页查询中排序与效率问题(国外英语资料) The raw paging query Sql code is as follows: Select, ROWNUM, RN, t.id, ID, , YYB, , XM, t.MC, from, tZDYSX T, tuser, u, lborganization, O, where, t.cjr=u.id, and, id=code, and, t.gx = Order by ID The results are as follows: RN, ID, YYB, XM, MC , 349, a Securities headquarters administrator testing 496, a Securities headquarters administrator holds more than 10000 shares of Hong Kong 5102, a Securities headquarters administrator ten years planning 14105, a Securities headquarters administrator development channels for Shanghai 11106, a Securities headquarters administrator Vanke A 12107, a Securities headquarters administrator 11 13108 client of a Securities headquarters todays birthday 2109, a Securities headquarters, the administrator, customer status is normal 6110, a Securities headquarters administrator no transaction 7111, a Securities headquarters administrator OA 8112, a Securities headquarters administrator lucky customers 9113 risk management of a securities head office 10114, a Securities headquarters administrator TST An Changbiao customer 22115 normal Baisha online transactions 1118, a Securities headquarters administrator 213 18119 the client number of a Securities headquarters contains 1008 17120, a Securities headquarters administrator AAA 19123, a Securities headquarters administrator ssssssss 20124, a Securities headquarters administrator www 21126, a Securities headquarters administrator 123123 15127, a Securities headquarters administrator 1212 16128, a Securities headquarters administrator aaaaaa 22 rows selected Initially, I used the following Sql code query: Select * from (select, ROWNUM, RN, t.id, ID, , YYB, , XM, t.MC) From, tZDYSX, t, tuser, u, lborganization, O, where, t.cjr=u.id,, and, id=code, and T.gx = 1, order, by, t.ID) Where, rn10, and, rn=20; This method succeeds in paging, and results are as follows: RN, ID, YYB, XM, MC 14105, a Securities headquarters administrator development channels for Shanghai 11