Re: Update statistic questions

"Huy Vu" <huyv_at_usa.net> wrote in message news:3be35ad8$1_3_at_aeinews....
> Hi all,
>
> I usually do update statistic the Informix databases before doing the
> export.
>
> Oracle question: Do I need to do update statistic an Oracle Schema before
> export it?
>
> Informix question: Do I need to run the update statistic again after
import
> an Informix database?
>
> The same question with Oracle Schema that I'm trying to understand if the
> import will handle that or not.
>
> Thanks in advance for any advise.
>
> DH
>
>
>
>

Sigh, no version again! Is that so difficult? pre 8i
When exported with statistics=COMPUTE or statistics=ESTIMATE imp will compute or estimate statistics

8i
use the dbms_stats package to export statistics to your own tables, and import them in the dictionary after the import succeeded.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address