set autotrace on explain

SQL> SELECT count(*) FROM sales_range
  2  WHERE sales_date BETWEEN TO_DATE('20060501','YYYYMMDD') AND TO_DATE('20060531','YYYYMMDD');

  COUNT(*)
----------
     43202
-------------------------------------------------------------------------------------------------------
| Id  | Operation               | Name        | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |             |     1 |     8 |   172  (20)| 00:00:03 |       |       |
|   1 |  SORT AGGREGATE         |             |     1 |     8 |            |          |       |       |
|   2 |   PARTITION RANGE SINGLE|             | 43146 |   337K|   172  (20)| 00:00:03 |     2 |     2 |
|*  3 |    TABLE ACCESS FULL    | SALES_RANGE | 43146 |   337K|   172  (20)| 00:00:03 |     2 |     2 |
-------------------------------------------------------------------------------------------------------
リスト2　パーティション・プルーニングを機能させるSQL
SQLの実行計画の確認にはSQL*PlusのAUTOTRACE機能を利用します。