Hi Iyyappan,
I'm not a pro on database tuning however this is my 2 cents on the subject.

By analyzing you use the Cost based Optimizer than the rule base optimizer.
If your data constantly changing through DML statements then you
have to analyze the tables often to benefit from the CBO. On our system by
switching from RBO to CBO our production
database's speed improved a significantly. However I'm not sure about
deleting
the stats during the peak hrs on your database. Maybe someone can
give some thoughts on that.


Regards,
Bernita

-----Original Message-----
From: iyyappan [mailto:[Email Address Removed] Friday, February 28, 2003 9:17 AM
To: LazyDBA.com Discussion
Subject: ANALYZE TABLE command..


Dear Gurus,


* Does analyzing a table make any difference in performance?
* Gathering and deleting table stats is fine during the peak hrs and does
not affect table data.
* If it is making performance better then can I generate it on daily basis?
* What I should look into user_tables to get the analyze results.
* Is there any optimizer consideration during this pro

Thanks in advance,
Iyyappan.M


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page