Database DataWarehousing (MOSC)

MOSC Banner

How to force scan of single partition in query

edited Oct 11, 2010 6:24PM in Database DataWarehousing (MOSC) 6 commentsAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center