Re: PARTITION HASH INLIST -- QUERY

"Ind-dba" <oraclearora_at_googlemail.com> wrote in message news:378b724d-ca44-46f2-b3b8-37ea58c33945_at_x5g2000prf.googlegroups.com...
>I need your help in a SQL tuning exercise:
>
> SQL:
> =======
> select /*+ gather_plan_statistics index(ag,PK_AD_Y) */ count
> (t.EDIT_STATUS)
> , count(ag.cr_date)
> from CMPGN.TE_Y t
> join CMPGN.AD_Y ag on ag.ad_grp_id=t.ad_grp_id
> and ag.ad_grp_id in
> (
> ..,
> ..,
> 997 values
> )
> order by t.acct_id, ag.cmpgn_id, t.ad_grp_id, t.term_id;

What version of Oracle

Can we see the execution plans without the 'allstats last' option so that we can see the predicted cost, and the pstart/pstop information.

For each table - how many partitions, and how which column is it partitioned on.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com