Re: Subquery partition pruning
- From: amonte <ax.mount@xxxxxxxxx>
- To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 Apr 2010 21:58:39 +0200
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
desc D_DATE
Name Null? Type
---------------------- -------- ------------
DATE_EID NOT NULL NUMBER(38)
..........
desc T_MOBILE_EVENT
Name Null? Type
---------------------- -------- ------------
DATE_EID NOT NULL NUMBER(38)
TIME_EID NOT NULL NUMBER(38)
..........
2010/4/1 Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
> What are the partition/subpartition key columns (as specified in the DDL)?
>
> On Thu, Apr 1, 2010 at 7:27 AM, amonte <ax.mount@xxxxxxxxx> wrote:
> > T_MOBILE_EVENT is partitioned (and subpartitioned) in two columns where
> > leading column is DATE_WID (so pruning is still possible).
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
Other related posts:
