Oracle Database Discussions

Hi all,

I have a table cartao with 200000 rows
How can I do to the query bellow read only some partitions
and not to do a FTS?

select * from
( select distinct card0_.pan as pan0_, cardstatus1_.id_cartao_status as id_carta1_1_
  from cartao card0_, cartao_status cardstatus1_
  where card0_.id_cartao_status=cardstatus1_.id_cartao_status(+)
  and ((card0_.id_cartao_tipo=1 ))
  order by  card0_.pan )
where rownum <= 10

Is there a way to this?

Is there a way to reduce I/O for this case.?

Rows     Row Source Operation
-------  ---------------------------------------------------
     10  COUNT STOPKEY
     10   VIEW
     10    SORT UNIQUE STOPKEY
 142870     NESTED LOOPS OUTER
 142870      PARTITION HASH ALL PARTITION: 1 8
 142870       TABLE ACCESS FULL OBJ#(59128) PARTITION: 1 8
 142869      INDEX UNIQUE SCAN OBJ#(54003) (object id 54003)

thanks