Re: Analyze Table

From: Rob K <robkato_at_earthlink.net>
Date: Sat, 21 Jul 2001 21:24:10 GMT
Message-ID: <bxk07.672$zg4.115974@newsread2.prod.itd.earthlink.net>

You should take a look at the dbms_stats package. It has a lot of functionality to help you analyze your system.

Rob

"Sathish Balas" <sathishudercor_at_home.com> wrote in message news:sV707.141042$qc.16784868_at_news1.rdc1.va.home.com...
> Hi
>
> What factors to consider before analyzing a table ?
>
> We have a table with 15mil rows . We have been analyzing every week . I
just
> do a analyze table <table_name> estimate statistics 33 per cent ; (not the
> exact syntax) . I read somewhere that do an estimate of 20 % and analyze
> just the indexes . If the data is skewed a lot then generate histograms .
Is
> this the right approach ?
>
> And i want to do the analyze in parallel ? How do i do it ?
> Can you point to documentation please ?
>
> Thanks
> Sathish
>
>
>
Received on Sat Jul 21 2001 - 16:24:10 CDT