I noticed if using dbms_stats.gather_table_stats , the sql plan some time changed to high cost plan and run much slow. If using analyze table command again, the plan set back to faster one.
Any one knows when should using which methord?
The problem is, each one help certain sqls run faster, but not always.
Thanks.


Oracle LazyDBA home page