SELECT ROWID, ani, dnis, message FROM tbl_sms_talkies WHERE ROWNUM <= "1000" ========================= Explain plan for the above query ================================== 1000 rows selected. Execution Plan ---------------------------------------------------------- Plan hash value: 2362346581 -------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 21 | 3549 | 136 (0)| 00:00:02 | |* 1 | COUNT STOPKEY | | | | | | | 2 | TABLE ACCESS FULL| TBL_SMS_TALKIES | 21 | 3549 | 136 (0)| 00:00:02 | -------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - filter(ROWNUM<=1000) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 841 consistent gets 0 physical reads 0 redo size 89689 bytes sent via SQL*Net to client 1246 bytes received via SQL*Net from client 68 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1000 rows processed