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 LazyDBA home page