Well, partition level statistics is useful only when Oracle is able to
figure out which partition to target at parse time. I.e. if you use literal
for partition column(s). Otherwise, global stats should be used. Wolfgang,
please correct me if I'm wrong.
Alex
2005/10/15, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>:
>
>
>
> Alex, Wolfgang, List
>
> WOW. Any info on the following, if possible?
>
> We have a Table which is RE-Created Daily with respective Partition
> names changing daily Date-wise i.e. <Partition Name>_<Day of Month>.
>
> Can Statistics gathered Once into STATTAB be SQL Updated Suitably for
> Changed Partition names & IMPORTED thereafter Daily? If so which
> fields/Columns?
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 15 2005 - 17:47:01 CDT
