sql 优化 Oracle

<select id="getProposalMainList" parameterType="java.util.Map" resultMap="BaseResultMap">
    SELECT main_id, user_id, proposal_name, total_amount, total_fee, create_time, modify_time,
    create_by, modify_by, state, pdf_url, is_delete, holder_age, holder_sex, holder_social_security,
    holder_job_detail, holder_name, holder_job_code, holder_job_cate
    From(
    SELECT main_id, user_id, proposal_name, total_amount, total_fee, create_time, modify_time,
    create_by, modify_by, state, pdf_url, is_delete, holder_age, holder_sex, holder_social_security,
    holder_job_detail, holder_name, holder_job_code, holder_job_cate, row_number() over( ORDER BY
    create_time DESC ) therow
    FROM (
    SELECT ipm.main_id, ipm.user_id, ipm.proposal_name, ipm.total_amount, ipm.total_fee,
    ipm.create_time, ipm.modify_time, ipm.create_by, ipm.modify_by, ipm.state, ipm.pdf_url,
    ipm.is_delete,ipm.holder_age,ipm.holder_