Re: Subquery partition pruning
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: amonte <ax.mount@xxxxxxxxx>
- Date: Thu, 1 Apr 2010 15:11:25 -0700
In order to get partition elimination with subquery pruning you need
to specify both columns in the partition key. Since your query does
not include TIME_EID, partition elimination with subquery pruning can
not take place.
On Thu, Apr 1, 2010 at 12:58 PM, amonte <ax.mount@xxxxxxxxx> wrote:
> here are the informations, I am gathering statistics now, refreshing and see
> how this goes, using sample percent 1 since the table is huge, thanks
>
> partition_key
> NAME OBJEC COLUMN_NAME COLUMN_POSITION
> -------------- ----- ---------------- ---------------
> T_MOBILE_EVENT TABLE DATE_EID 1
> T_MOBILE_EVENT TABLE TIME_EID 2
>
> subpartiton_key
> NAME OBJEC COLUMN_NAME COLUMN_POSITION
> -------------- ----- ---------------- ---------------
> T_MOBILE_EVENT TABLE TXES_ID 1
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
