带有distinct的分页SQL优化

 给物流系统的开发人员优化一支报表SQL，情况如下： 

原分页SQL:

select *   from (select row_.*, rownum rownum_          from (select T__.*, rownum as ROWNUM__                  from (        select