Build an Oracle DBA on a firm foundation of sound practices and technical knowledge!
Wednesday, May 21, 2008
Determining the Bad Source of statistics
Basic Analysis: 1.Is the rows estimate from explain plan correct? 2.Is the rows estimate correct in all_[tab|part]_col_statistics? 3.Is the sample size large enough to give accurate row estimates? 4.Obtain accurate stats and recheck the plan