Re: Partitioned table usage question

Arun,

in the execution plan you can see statement like 'partition concatenated', if more than one partition will be used by your query. If only one partition will be used, than your execution plan look like this

• ...
  • Table Access*Full of table_name...
    • parallel to serial /*+ ROWID(A1) ...*/ select... PARTITION...

An other way is to query the Table 'PLAN_TABLE'. There are three interest columns for you:

- PARTITION_START
- PARTITION_STOP
- PARTITION_ID

Bye,
Jan

aa_at_triad.com wrote:

> I have a table that is currently partitioned on a date column ( partitioned
> at month boundaries). Using explain plan how can I determine that the
> optimizer is looking for data from a specific partition ( i.e. partition
> pruning) based on the query I execute. e.g I need to know that when I select
> data for 12/15/1998 the optimizer looks only in the December partition and
> then uses the index on the date column to find the exact row I need. Thanks,
>
> Arun
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Dec 16 1998 - 04:28:08 CST