Not sure what you mean by 'sync' so it depends, but there's no such thing as
analyzing to much, make sure you use dbms_stats

-----Original Message-----
From: Narayan Vaidyanathan [mailto:[Email Address Removed] 28 February 2003 12:40
To: LazyDBA.com Discussion
Subject: Is Analyze to be done again?



Hi All,

I analyzed my tables on test and then do a sync of the test to Production.

Is it necessary for me to do the analyze schema again?

TIA

Narayan






_____

Do you Yahoo!?
Yahoo! <http://rd.yahoo.com/finance/mailtagline/*http://taxes.yahoo.com/>
Tax Center - forms, calculators, tips, and more

Oracle LazyDBA home page