Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> partition query information

partition query information

From: Adi Hirschtein <adi_at_zetapoint.com>
Date: Mon, 23 Oct 2006 17:15:58 +0200
Message-id: <0J7L00K86HBUU4I1@i_mtaout2.012.net.il>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 23 2006 - 10:15:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US