Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: exporting / importing Object Stats?

Re: exporting / importing Object Stats?

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Sun, 16 Oct 2005 00:45:00 +0200
Message-ID: <c2213f680510151545j522480bfo@mail.gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US