Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: RE: RE: Creating Histograms
Oh, ya, that reminds me.
I also found a series of articles in the
databasejournal
www.databasejournal.com/features/oracle/print.php/10893_3098241_4
by Amar Kumar Padhi. These articles discuss both saving statistics and histograms (among other things). Haven't "dug in" to them yet, as there's a lot of info. Might be worth a glance.
Good luck!
Barb
> --- "Freeman, Donald" <dofreeman_at_state.pa.us> wrote:
>
> Thank you Barbara and everyone who contributed to
> this thread. I've got enough stuff to start doing
> something!
>
> Don:
> I've been closely following your posts lately. I
> seem
> to be going through exactly the same stuff
> (histograms, how to gather stats, etc.), and I keep
> getting really confused.
>
> I found this article:
>
>
http://www.oracle-base.com/articles/8i/CostBasedOptimizer(CBO)AndDatabaseStatistics.php
>
> In particular, the "transfering stats" portion is
> more
> informative than other information I've collected.
>
> Hope that helps.
> Barb
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Jul 27 2004 - 10:52:50 CDT