partition query information

  • From: Adi Hirschtein <adi@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 23 Oct 2006 17:15:58 +0200

Hi guys,

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.

 

Thanks,

 

Adi

Other related posts: