Re: Reappearance of statistics!

badri_at_cc.gatech.edu (badri) wrote:

>Hi:
 

> I am trying to analyze the "mysterious" reappearance of
>statistics. I exported the entrire database (none of the tables
>had statistics) to a different machine and the init.ora file
>has optimization set to rule and *ALL* of the tables have statistics
>now - how? Does export cause it to get statistics? Seems counter-intuitive.
 

>Any leads appreciated,
>thanks a lot,

Export will automatically estimate statistics.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!