Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> partition query information
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-lReceived on Mon Oct 23 2006 - 10:15:58 CDT
![]() |
![]() |