set autotrace on explain
SQL> SELECT * FROM sales_range
2 WHERE salesman_name='ASHISUTO1';
SALESMAN_ID SALESMAN_NAME SALES_AMOUNT SALES_DA
----------- ------------------------------ ------------ --------
1 ASHISUTO1 100 06-05-25
---------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
---------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 526K| 13M| 669 (19)| 00:00:09 | | |
| 1 | PARTITION RANGE ALL| | 526K| 13M| 669 (19)| 00:00:09 | 1 | 4 |
|* 2 | TABLE ACCESS FULL | SALES_RANGE | 526K| 13M| 669 (19)| 00:00:09 | 1 | 4 |
--------------------------------------------------------------------------------------------------- |