SELECT
*
FROM
(
SELECT
a.*,
ROWNUM rnum
FROM
(
SELECT
RES.*
FROM
ACTIVITI_T.ACT_HI_VARINST RES
WHERE
RES.PROC_INST_ID_ IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10')
ORDER BY
RES.ID_ ASC
) a
WHERE
ROWNUM <2147483647) WHERE rnum >=1
生效SQL
SELECT
*
FROM
(
SELECT
a.*,
ROWNUM rnum
FROM
(
SELECT
/*+ enable_index_join(1) INDEX("RES""ACT_IDX_HI_PROCVAR_PROC_INST")*/
RES.*
FROM
ACTIVITI_T.ACT_HI_VARINST RES
WHERE
RES.PROC_INST_ID_ IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10')
ORDER BY
RES.ID_ ASC
) a
WHERE
ROWNUM <2147483647) WHERE rnum >=1;