oracle 如此sql

gerry_wxy

各位大大，下面sql帮帮看如何优化：
    select UIN from (select my_table.UIN,rownum as my_rownum from (   select UIN   from user_info_tb   where (uin between 8000000 and 10000000) and     SLAVE_FLAG=2 and    FACELINK is not null order by uin desc   ) my_table where rownum<:1 )where my_rownum>=:2
走了全表扫描，太耗CPU资源？