Re: Subquery partition pruning

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: