How to force scan of single partition in query
Hi,
How can I force a single partition scanning in a table? is there any hint for it ?
I have a query on table t1 which is range partitioned on load_date when I see explain plan for following query :
SELECT * FROM t1 a
WHERE a.load_date BETWEEN TRUNC(SYSDATE)-3 AND TRUNC(SYSDATE)-2 ;
It shows
----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-O
----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2737M | 1025G | 4088K (3)| 13:37:37 | | | | |
| 1 | PX COORDINATOR | | | | | | | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10000 | 2737M | 1025G | 4088K (3)| 13:37:37 | | | Q1,00 |
| 3 | PX BLOCK ITERATOR | | 2737 M | 1025G | 4088K (3)| 13:37:37 | 1 | 1283 | Q1,00 | PCW
| 4 | TABLE ACCESS FULL | T1 | 2737 M | 1025G | 4088K (3)| 13:37:37 | 1 | 1283 | Q1,
How can I force a single partition scanning in a table? is there any hint for it ?
I have a query on table t1 which is range partitioned on load_date when I see explain plan for following query :
SELECT * FROM t1 a
WHERE a.load_date BETWEEN TRUNC(SYSDATE)-3 AND TRUNC(SYSDATE)-2 ;
It shows
----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-O
----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2737M | 1025G | 4088K (3)| 13:37:37 | | | | |
| 1 | PX COORDINATOR | | | | | | | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10000 | 2737M | 1025G | 4088K (3)| 13:37:37 | | | Q1,00 |
| 3 | PX BLOCK ITERATOR | | 2737 M | 1025G | 4088K (3)| 13:37:37 | 1 | 1283 | Q1,00 | PCW
| 4 | TABLE ACCESS FULL | T1 | 2737 M | 1025G | 4088K (3)| 13:37:37 | 1 | 1283 | Q1,
0