RE: partition query information

Hi Adi

> Do u guys know if there is any way to get the exact information
> about which partition
>
> Oracle will us in a query before running it?
>
> In the explain plan Oracle doesn't point on the exact partition,
> it's just say if it goes to scan all partition or just some of them
>
> But I'm interested in the name of the partition to be queried from.

With explain plan you get a partition ID. You can get the partition name with a query like the following one:

select partition_name
from user_tab_partitions
where partition_position = <part_id> and table_name = <tab_name>

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l