这个分页执行需要7-9秒，希望能做到秒出，请大家指点一下

select *
from (select tmp_page.*, rownum row_id
from (SELECT /*+ use_nl(T2,T3) use_nl(T2,T) index_combine(T3 BA_USER_INFO_T_N2 BA_USER_INFO_T_N6)*/
T.MEMBER_ID,
T.LABEL_ID,
T2.MEMBER_NAME,
T2.MEMBER_NO,
T3.OPEN_ID
FROM BIZCRMDB.CUX_LABELS_MEM T,
BASEDB.BA_MEMBER_INFO_T T2,
BASEDB.BA_USER_INFO_T T3
WHERE T.MEMBER_ID = T2.MEMBER_ID
AND T2.MEMBER_ID = T3.MEMBER_ID
AND T3.OPEN_ID is not null
AND T.LABEL_ID = 72) tmp_page
where rownum <= 150100)
where row_id > 150000