我现在有这样一个sql
SELECT *
FROM (SELECT ROWNUM AS NUM,
TAXRATE,
MPTYPE,
ITEMCODE,
BARCODE,
ITEMNAME,
ITEMSPEC,
INVUNITCODE,
PLANPRICE,
PURUNITCODE,
PURPRICE,
SALEUNITCODE,
SALEPRICE,
VALIDDAYS,
ITEMWEIGHT,
ISENABLED,
ISACTIVE,
ORDBATCHPOLICYTYPE,
ORDBATCHQTY,
ISRECEIVEQTYBILL,
ISSINGLE,
ITEMTYPENAME
FROM (SELECT/*+ parallel(a,7)*/ A.TAXRATE,
A.MPTYPE,
A.ITEMCODE ITEMCODE,
A.BARCODE BARCODE,
A.ITEMNAME ITEMNAME,
A.ITEMSPEC ITEMSPEC,
A.INVUNITCODE INVUNITCODE,
A.PLANPRICE PLANPRICE,
A.PURUNITCODE PURUNITCODE,
A.PURPRICE PURPRICE,
A.SALEUNITCODE SALEUNITCODE,
A.SALEPRICE SALEPRICE,
A.VALIDDAYS VALIDDAYS,
A.ITEMWEIGHT ITEMWEIGHT,
A.ISENABLED ISENABLED,
A.ISACTIVE ISACTIVE,
A.ORDBATCHPOLICYTYPE ORDBATCHPOLICYTYPE,
A.ORDBATCHQTY ORDBATCHQTY,
A.ISRECEIVEQTYBILL ISRECEIVEQTYBILL,
A.ISSINGLE ISSINGLE,
B.ITEMTYPENAME ITEMTYPENAME
FROM PUB_ITEM_MASTER A, PUB_ITEM_TYPE_CODE B
WHERE B.ENTERPRISECODE(+) = A.ENTERPRISECODE AND
B.ITEMTYPECODE(+) = A.ITEMTYPECODE AND
A.ENTERPRISECODE = 'shjt'))
WHERE NUM >= 1 AND NUM <= 15
里边的num是为了分页,我如果不分页,在pl/sql中查询很快,但是分页后为什么很慢,并且我们需要把选择的数据count出来,然后才可以利用分页技术来分页,
不知道各位朋友,你们是怎么处理的。